Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2006-08-10 : 06:24:05
|
| Hi,I am trying to run a sql statement to execute a procedure in oracle.I am used to sql server and this is my first time using oracle.This is what I am running and it gives the error: invalid sql statement.Any thoughts please?EXECUTE RESOURCE_DEVELOPMENT.PHILIPS_REPORTS.ConfirmUDFExists('COM_X');I have tried takiing out the semi colon at the end and even tried exec instead of execute...Thanks |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-08-10 : 06:25:54
|
| This is SQL Server forum try to post on www.dbforums.comChirag |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-10 : 06:27:03
|
| try call instead of exec.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-08-10 : 12:31:47
|
quote:
Originally posted by fmardani
Hi,I am trying to run a sql statement to execute a procedure in oracle.I am used to sql server and this is my first time using oracle.This is what I am running and it gives the error: invalid sql statement.Any thoughts please?EXECUTE RESOURCE_DEVELOPMENT.PHILIPS_REPORTS.ConfirmUDFExists('COM_X');I have tried takiing out the semi colon at the end and even tried exec instead of execute...Thanks
I hope you know well that this is SQL Server Forum  MadhivananFailing to plan is Planning to fail |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-10 : 12:53:10
|
| Probably did after reading chiragkhabaria's post.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2006-08-16 : 11:08:54
|
| solved. thanks |
|
|
|
|
|
|
invalid sql statement in oracle