executing SQL stored procedure in DIAdem

[rskbgm]

Hi all,

I am trying to execute SQL stored procedure through DIAdem. I am using DIAdem command SQL_ExecDirect. It gives me error. But i tried some other small stored procedures which inserts values in the table, those worked with same command.

I will be glad if any of you have solution for the above.

Its very urgent. Any suggestions as early as possible.

Thanks

ROHIT

[Brad_Turpin]

Hi ROHIT,

Here's an example of calling stored Oracle procedures from DIAdem. Let us know if it does not answer your questions.

Regards,
Brad Turpin
DIAdem Product Support Engineer
National Instruments

[rskbgm]

Hi Brad,

I am still unable to execute the SP correctly as the oracle connection is not the same with MSSQL.
The SP which I am trying to execute has several queries within it like accessing views with where clause. And few other select queries. The same procedure when called directly in query analyser works fine without any issues but throws an ODBC error from DIAdem.

As said earlier I am able to excute an simple SP through DIAdem.

Please help me on this.
Expecting for your early response

Thanks,
Rohit

[Brad_Turpin]

Hi Rohit,

You have given me no useful information to help you with. You say that simple stored procedures run when called from DIAdem, but that complicated ones do not. Does the stored procedure edit the data base or return records? Can you execute the complicated stored procedure from a simple VBScript run in the Windows VBScript host using straight ADO objects?

Can you give me the SQL code you are passing to the SQL_ExecDirect() command?

Brad Turpin
DIAdem Product Support Engineer
National Instruments