- This topic is empty.
- 02/18/2011 at 10:52 am #4827
If you got the Text command to work fine with Oracle then here is a sample about how to create a Stored Procedure and use it from QWP.
I use HR Oracle database that gets installed with Oracle 10g Express Edition.
OR REPLACE PROCEDURE HR.GetEmployee
OUT EMPLOYEES.LAST_NAME%TYPE ,
and this is how I set the QWP to call the stored procedure created above.
I'd recommend you to try the best product ever made for making Oracle database work easy:
Quest Toad for Oracle.
Please let me know if you have any questions.
If you consider that the answer was helpful please don't hesitate to mark it as "Answered”.
- 02/18/2011 at 11:15 am #6939
That is actually how I've been trying to use the Stored Procedure, but when I get to the web part, I can't enter a Method. Is there something the system administrator need to setup?
- 02/18/2011 at 11:21 am #6940
Two more things,
We've been a TOAD shop for over 10 years, love the product.
We are using an Oracle 8.1 DB.
- 02/18/2011 at 11:22 am #6943
The user that you use in the Configuration Editor tool has to have proper permissions over the database you try to use.
In my case I use SYS so I have all the permissions. Please check with you DBA for permissions.
- 02/18/2011 at 11:33 am #6941
Glad to hear about TOAD.
I don't know what to say more, talk to your DBA and see what he thinks. As I showed above my SPs show up in my web part.
- 06/30/2011 at 10:10 am #4082
I’ve been trying to do the encapsilation with Oracle Stored Procedures, but all the examples are for SQL Server.
1) How do i create the procedues so that the Web parts can use them to fill in a qSIListView
2) Do i need to create Endpoints in Oracle and if I do how?
Does anybody have some examples, or setup steps for using Stored Procedures in the Oracle DB?
I get Text Methods to work fine, but I’d like to be able to use dynamic queries in some of my procedures.
- 06/30/2011 at 10:10 am #6945
I'm still haveing trouble with using stored procedures, but I think it is the Schema we are connecting too, APPS has too many Stored Procedures, and the Web part times out when trying to create a list for the methods.
We're working on having a Webparts Schema for us to put stored procedures and view into and connect to the Oracle DB with that schema.
- 07/14/2011 at 6:57 am #6942
Any update regarding the Oracle SPs?
You must be logged in to reply to this topic.