The front end is a Macintosh/Windows Database, 4th Dimension, which connects to Oracle via ODBC. I'm using the 4th Dimension ODBC extensions. A code example in VB would be helpful, as would a general description of what has to be done in the Oracle Procedure/Package to get the data there.
In MSSQL Server you could use a Select statement in a stored procedure to return many rows of data. In Oracle, it seems that you need PL/SQL to open a cursor, return the rows in a cursor and then print the cursor using SQL/Plus or a similar tool. I need to use an ODBC connection to run a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.