Calling ORACLE PROCEDURES from Paradox 
Author Message
 Calling ORACLE PROCEDURES from Paradox

I'm using PDX 7.0 with latest SQL links (3.0). By using executeSQL()
method I am NOT ABLE TO CALL AN ORACLE STORED PROCEDURE. ExecuteSQL()
method does NOT appear to be "pass-through" because some SQL statements
simply do not get executed (they run otherwise correctly under Oracle's
SQL Worksheet).

Does anybody have a solution of how to do it? I am in a desperate need
for a solution (currently I run external SQL Plus to process it which is
VERY slow to execute and VERY uncomfortable for a workstation setup...)

Any suggestions would be greatly appreciated.

I am using Oracle 7.3.3.2 Workgroup Server for NT 4.0 and SQL*net
version 2.0 (TNS with TCP/IP and/or Named Pipes).

Radek Hulan



Tue, 26 Oct 1999 03:00:00 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Oracle/Paradox - stored procedure calls

2. Calling Stored Procedure that calls Stored Procedure in ASP

3. How to call an Oracle Stored procedure from MSSQL Server Stored Procedure

4. Calling Oracle Stored Procedure from within SQL Server Stored Procedure

5. asp and Oracle DB(how to call oracle stored procedure/functions from asp)

6. Cursor fails when called procedure called from trigger

7. Using ODBC call rather than TSQL execute to call a stored procedure

8. Called and Calling store procedure problem !!

9. RPC call occurs for each Stored Procedure call?

10. Calling procedures from PL/SQl functions (called from a SQL stmt)

11. Calling an Oracle Procedure from a DTS

12. Calling Oracle stored procedure from DTS


 
Powered by phpBB® Forum Software