Oracle Stored Procedure not working

[Former Member]

Hi Guy's,

I want to connect directly from Visual Composer to Oracle Database 10.2.x.x using Oracle Stored Procedure and JDBC System to demonstrate how easy you can show data vith VC. So I have created a simple Oracle Stored Procedure, a JDBC System with a valid alias, User mapping (Portal User --> Oracle User).

When I invoke the stored procedure I receive the following error: "Portal request Failed (Could not execute stored procedure)". The Stored Procedure is working fine in Oracle iSQL*Plus.

Any idea's?

Thanks,

Ridouan

[Former Member]

Hi,

did you use the portal JDBC as it is described here:

<a href="https://wiki.sdn.sap.com/wiki/display/VC/Cannotseetables">https://wiki.sdn.sap.com/wiki/display/VC/Cannotseetables</a>

Best Regards,

Marcel

[former_member185086]

Hi

when u configured the Database in VC r u able to execute any query in Visual admin. Did u give right connection URL and Driver name.

Let me know

Regards

Satish

[former_member203343]

Hi Ridouan,

If the stored procedure is returning data in the RETURN method, it won't work. Try to do a simple select statement so what will be returned is a result set.

Natty