Calling Oracle Package using Oracle Connector

[dganeshm]

I am trying to call Oracle Package using Oracle Connector using the PL/SQL Block ,

exec ACMS.util_acms.truncate_table('ACMS.ACRU_MNTNC_WRK') but I am getting an error :

Error code: 6,550, Error message: ORA-06550: line 1, column 12:
PLS-00103: Encountered the symbol "ACMS" when expecting one of the following:
:= . ( @ % ;
The symbol ":=" was substituted for "ACMS" to continue.. (CC_OraStatement::executePlSql, file CC_OraStatement.cpp, line 3,710)

When I execute "call ACMS.util_acms.truncate_table('ACMS.ACRU_MNTNC_WRK')" from after or before SQL Statement section it works , I am not sure why it does not work for exec. That is how I use it from toad and that does not give any issues.. Please advise.

[lstsaur]

EXECUTE is a SQL*Plus command. So what you have to do is to invoke and get to the SQL*Plus prompt first. Put all these statements in a shell script and execute it from DS.

[chulett]

Stick with 'call'. As noted, save the anonymous block for something that speaks sqlplus.

[dganeshm]

I am using 'call' , this gives the correct results.

[lstsaur]

Of course CALL command is going to work. Just trying to show you how to use the EXECUTE command to execute your packaged stored procedure from the DS environment.

[dganeshm]

Thanks lstsaur, point duly noted.