Pass Through Query to execute oracle procedure

[marathonlady]

I have a pass-through query that is passing a pair of variable parameters to execute an oracale procedure.

Here it is:

Exec P_AssetTagUpdate ('ABC', 'DEF')

note, here we are trying to change a pc's tag number from ABC to DEF.

User gets the message:

ODBC call failed
[Oracle][ODBC] Syntax error or access violation (#0)

Another note: the user can execute the exact statement in oracle SQL +. Anyone know what the problem is?

Thanks.

 

[RV]

Did you set up an ODBC connection to connect to the (ORACLE) database through SQL*Plus?

RV