Call Stored procedure in Oracle 8 OCI stage

rajeev_prabhuat · Post by **rajeev_prabhuat** » Wed Dec 29, 2004 11:33 pm

Hi,

I want to call an stored procedure from Oracle 8 OCI stage, i called the procedure in the Before SQL as follows:

call TEST_SAN2();

But it showed me the following error

SAMPLE_ORACLE_CALL_PROC..Oracle_OCI_8_0: ORA-06576: not a valid function or procedure name

I tried executing the procedure from orace it is working fine. Can anyone help me in this regards.

Regards,
Rajeev Prabhu

T42 · Post by **T42** » Thu Dec 30, 2004 12:44 am

Do it within a SQL statement.

rajeev_prabhuat · Post by **rajeev_prabhuat** » Thu Dec 30, 2004 1:14 am

T42 wrote:Do it within a SQL statement.

Do you mean to say by giving Begin and end statement, i tried this also that is also not working.

Regards,
Rajeev Prabhu

ogmios · Post by **ogmios** » Thu Dec 30, 2004 4:37 am

In v7.5 you have the stored procedure stage.

Ogmios

chulett · Post by **chulett** » Thu Dec 30, 2004 8:49 am

No, you don't need to build an anonymous block to call the procedure, a simple 'call' statement is supposed to work.

I don't make use of them but others have reported success here several times using that syntax. From what I recall, do it from the Custom SQL area, not the Before or After SQL tabs.

Try it without the trailing semi-colon first. And unless you have a public synonym sitting over it, you may need to qualify it with the schema owner unless you are connecting to Oracle as that owner.

wdudek · Post by **wdudek** » Tue Jan 04, 2005 12:18 pm

I know we do this, but can't find the job at the moment. I know that we use execute instead of call, and that it is in the after sql on ours, so I would expect the before sql to work as well.