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 |
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
 Posted - 2008-03-19 : 11:10:09
|
| Hi pals,I am facing problems while calling Oracle stored procedure which has no parameters.I have used Microsoft OLE DB provider for Oracle.I have taken one Execute SQL task and set the SQLStatement as call procedurenameI also set the IsStoredProcedure property to True for Execute SQL task.Is there any synatx problem? I am getting an error saying Error: 0xC002F210 at Call Sp, Execute SQL Task: Executing the query "(call sp_procname)" failed with the following error: "ORA-00928: missing SELECT keyword.I removed the curly braces for the SQL statement and again ran the Package, i am getting the below errorExecuting the query "call sp_procname" failed with the following error: "ORA-06576: not a valid function or procedure nameCan anyone help me out on this regard!Thanks in advance |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-03-19 : 11:13:09
|
| Change "call procedurename" to "Exec procedurename".Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2008-03-19 : 11:19:54
|
| Hi harsha,I am getting a new Error saying failed with the following error: "ORA-00900: invalid SQL statementIs there anything wrong in setting the Properties or so?If so, please help me out! |
|
|
|
frank.svs
Constraint Violating Yak Guru
368 Posts |
Posted - 2008-03-20 : 03:28:21
|
| Hi Guys,There is no problem with user permissions.It is perfectly working fine in Oracle.Only thing is that i was unware of syntax of calling oracle stored procedure.Here is the solution{call procedurename} |
|
|
|
|
|
|
Error while calling oracle stored procedure!