MQSeries.net :: View topic - Dyanamic DSN in esql call procedure statment

Spidyctf · Posted: Fri Oct 03, 2008 3:06 am Post subject:

Hi

I am trying to call oracle stored procedure from esql in WMB V6.1.
follwing is the code for the same

CALL myproc(0,userName,typeValue,subTypeVal,cellNo,attribute1,attribute2,attribute3,attribute4,attribute5,attribute6,attribute7,attribute8,attribute9,
attribute10,attribute11,attribute12,attribute13,attribute14,attribute15,createdByUser,media,
createDate,status,incidentNo,returnCode,returnMessage) ;

CREATE PROCEDURE myproc (IN P1 INT,IN P2 CHAR,IN P3 CHAR,IN P4 CHAR,IN P5 CHAR,
IN P6 CHAR,IN P7 CHAR,IN P8 CHAR,IN P9 CHAR,IN P10 CHAR, IN P11 CHAR,IN P12 CHAR,
IN P13 CHAR,IN P14 CHAR,IN P15 CHAR, IN P16 CHAR,IN P17 CHAR,IN P18 CHAR,IN P19 CHAR,
IN P20 CHAR,IN P21 CHAR,IN P22 CHAR, IN P23 DATE, OUT P24 CHAR, OUT P25 INT,OUT P26 INT,OUT P27 CHAR)
EXTERNAL NAME "testschema.myproc";

In the esql node property i have set the DSN name to ORCL and this is working fine with this dsn.

Now i want to use the DSN dynamically for different instances. I have tried using the IN clause with the CALL statement wherein you can specify the DSN name.
But it is giving error stating invalid schema reference.

can anyone give some pointers