Oracle Stored Procedure

[Former Member]

Hello All,

I have successfuly instaled VC and connected it to an EP6 SP16. For the moment i developed a dummy application for mantaining phone contacts but the it only works for updating, inserting and deleting registers. I guess the problem is the stored procedure for selecting contact details (the query is as simple as select * into aux from z_phones, where aux type is z_phones%rowtype ). Our database is Oracle 9.2 so the sql syntax is different from all the examples we've found which seem were done for sql server.

Could anybody tell us where to find any guide for creating stored procedures for Oracle DB to be used with VC?

Thanks in advance.

[Former Member]

Hi all,

I'm also facing the same problem with Oracle stored procedure.

How can I select few/all rows from a table to be displayed in VC????

If you hv solutions, please let me know.

Any help is appreciated.

Thanks,

Namita.

[Former Member]

If you are using a jdbc system you have to call stored procedures which in Oracle are written in PL/SQL. See simple tutorial <a href="http://infolab.stanford.edu/~ullman/fcdb/oracle/or-plsql.html">here</a>.

If you are using a bi_jdbc system to connect to your Oracle base you can enter sql directly in VC - for example:

"Select NAME , USER_ID from SCHEMANAME.TABLENAME WHERE USER_ID = 93 "

For a good how to see: <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/6339e7d4-0a01-0010-1c98-db00e52e989a">How to Use SQL Editor Within Visual Composer</a>

Hope it helps

Henning

[Former Member]

Hi feda,

No special stored procedure is required for VC. VC fetches the normal stored procedures those are in the Oracle server. Please make the connections carefully with the Oracle server from the Portal side. Don't forget to map the users.

Thanks in advance,

Deep

[Former Member]

Hi Deep,

I dont have any problem neither with the connections nor the user's mapping. My only problem is with the sql syntax for Oracle servers.

Do you have any example code for creating an stored procedure in Oracle for selecting a single row of a table and returning its data to the VC?

Thanks.