Skip to Main Content

Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Calling MySQL Stored Procedure within View Object SQL Statement?

490060Apr 14 2006 — edited Apr 16 2006
I'm trying to call a MySQL stored procedure within the SQL Statement area of the View Object Editor: 'call testproc(?)'

The View Object SQL Statement Editor automatically appends a SELECT statement resulting in:
SELECT * FROM (call testproc(?)) QRSLT WHERE 1=2

Since this is a non-Oracle database, I can not use the Query Builder to freeform enter the Query.

How can I get around this so I can call the MySQL Stored Procedure from the View Object without the Original SQL being edited?

thanks
Tom
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 14 2006
Added on Apr 14 2006
9 comments
5,874 views