can't run wrapped package using oraScript?

[John Young]

can't run wrapped package using oraScript? any help ? thanks

[Paul]

TOraScript can execute wrapped script. Try to execute this script using SQL Plus. Send please small demo project to demonstrate the problem to ODAC support email.
Please specify the following information:
- Version of Delphi or C++ Builder
- Version of ODAC. You can see it in About sheet of TOraSesion Editor
or Oracle\About menu of IDE
- Version of your Oracle server and client

[John Young]

Hi Paul,

thanks for your response, I have tested orascript in odac version 4.15.0.13 and version 5.10.0.5.
if using NET option, get ORA-01003 no statement parsed.
if using oci,get ORA-01036 illegal variable name/number.
if using sql/plus to run the wrapped script no error.
Though get error when run the script , I can call some wrapped function correctly. but with complex function using date parameter ,I get invalid dateformat error.

I guess ODAC may have done some work on the script before sent to oracle.

thanks for your further help!

John

[John Young]

All tested using Delphi7,Oracle 9i 9.2.1

[Paul]

Send us please small demo project to demonstrate the problem and include script to create server objects to ODAC support address.

[Paul]

Thank you for information. We reproduced your problem with ORA-01036, ORA-01003 and fixed it. This fix will be included in the next ODAC 5 build.