I'm using PB 10.5 with Oracle 10i. I'm trying to create a datawindow with a stored procedure as its source but when I click on 'Finish' button in the datawindow wizard, I get the oracle error ORA-24334 which is talking about not having some descriptor handle.
I have other datawindows that are based on exactly similar stored procedures and they don't give me any problem.
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.