Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Basing a block on a stored procedure

Status
Not open for further replies.
celispb

celispb

Programmer
Apr 3, 2003
18
US
Developer 9i

I am trying to create a block based on a stored procedure. The stored procedure is returning a ref cursor not a pl/sql table.

I used the wizard to create the block and everything seems fine. However, when I compile the form the QUERY-PROCEDURE is not created. No error message or anything.

If I base the block on a stored procedure returning a plsql table it works fine.

The query data source arguments are set correctly. Is there anything that I am missing?

Thanks
 
Status
Not open for further replies.

Similar threads

BJCooperIT
  • Locked
  • Question
Problem running a form from Forms Builder
Replies
2
Views
176
BJCooperIT
BJCooperIT
Maahjoor
  • Locked
  • Question
apllication screen adjustment problem
Replies
0
Views
123
Maahjoor
Maahjoor
spd800c
  • Locked
  • Question
GIF icons not showing at runtime in Developer 10g
Replies
0
Views
123
spd800c
spd800c
sim133
  • Locked
  • Question
Oracle Stored Procedure
Replies
0
Views
45
sim133
sim133
GROKING
  • Locked
  • Question
Package that executes two Stored Procedures
Replies
1
Views
69
lewisp
lewisp

Part and Inventory Search

Sponsor

Back
Top