Skip to Content
avatar image
Former Member

Oracle Stored Procedure not working

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jul 19, 2007 at 02:57 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2007 at 10:45 AM

    Hi,

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

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

    Best Regards,

    Marcel

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 19, 2007 at 02:14 PM

    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

    Add comment
    10|10000 characters needed characters exceeded