Oracle Forms builder 6i: Unable to see stored procedures in data block wizard and therefore use data block wizard.
Facts:
Data block wizard can be successfully used to build blocks for tables in this schema (Man)
Can see procedure as a node under Database objects for appropriate schema (Man)
Can successfully execute procedure (proc_emps) in Oracle SQL Plus.
while in data bloxck wizard I click stored procedure radio block and go to next page, enter the procedure (proc_emps) and click refresh. No available cols populate.
Start Free Trial