Skip to Content
0
Former Member
Nov 28, 2008 at 06:03 PM

Problem while using oracle stored procedure in VC

42 Views

Hi All,

I have created JDBC system and connected my locally installed Oracle data base to the VC. I mapped the data base user to my VC user. I tested connection and it is fine. Further I see the DB alias in Visual Composer and I can drop stored procedures to my story board. I can define parameters, but when I am executing procedures I get the error message.

Problem: I can not execute stored procedures stored in Oracle data base. Error Message: Portal request failed. Could not execute stored procedure.

In the stored procedure, I have used select query, that returns set of records, so that I have used REF CURSOR as OUT Parameter. Is REF CURSOR supported by VC?. Else, any tricks available to solve this problem?.

Note: Stored Procedure of Sql server is working fine in VC.

Thanks,

Venkatesh R