Hello,

I have the following message calling an odbc stored procedure within an odbc sql general component : ORA-00907: missing right parenthesis

Context

connection: ODBC(PP)

driver: Oracle

version: 6.0

Connection string:

Samples

------------------------------------------------------------

The store procedure has been validated on TOAD.

The store procedure has been validated with these call statement within PP component:

Begin

MOVIES.I_PCK_MOVIES_SEARCHER.demander(param1 => 4152, param2 => 4);

End;

OR

Begin

MOVIES.I_PCK_MOVIES_SEARCHER.demander(param1 => \$(globalProperties 1), param2 => \$(globalProperties 2));

End;

{call MOVIES.I_PCK_MOVIES_SEARCHER.Collecter_results()}

------------------------------------------------------------

The following synthax didn't work with odbc(pp) but work fine with an ODBC(DSN) with Oracle driver.

Begin

MOVIES.I_PCK_MOVIES_SEARCHER.demander(param1 => ?, param2 => ?);

End;

Sql parameter mapping with properties or global properties

Thans for your help,

Samuel