Database Search
If you can't find the information using the categories below, post a question over in our WinBatch Tech Support Forum.
TechHome
ODBC
 |
- !!NEWSFLASH!!
- 1437 or 3437 Extender Load Error
- 3132 error when using DAO
- 521 Attribute string too long
- Access SQL Update
- An SQL Tutorial
- Automated ODBC Data Source creation
- Calling a MS SQL Server 2000 Stored Procedure
- Change database then Update then count rows
- Compact an Access Database
- COMPACT_DB and Password MDB Files
- Continue a SQL Query after a Warning Message from Driver
- Create a System DSN for a TXT File Problem
- Create an SQL DSN with User name and Password
- DSN Connection Strings
- Execute an Oracle stored procedure
- Explanation of ODBC Usage
- Get Installed Driver Information
- Get Parameters from a Stored Procedure
- How Does qBindCol Work
- How to Do a Simple Sql Query
- Invalid Cursor State Error
- MDAC Invalid Object
- Microsoft SQL Server ODBC driver Info
- More on How ODBC Works
- ODBC and Services
- ODBC and SQL
- ODBC DSN Maker
- ODBC DSN Port Configuration
- ODBC Extender with WebBatch problems
- ODBC on 64 bit System
- ODBC SQLDescribeCol Example
- ODBC WHERE Syntax Blank Data
- Pervasive SQL Syntax Error
- Problem Adding System DSN for SQL Server
- Problem Using qConfigData with the Oracle ODBC Driver
- qConnect Crashes with Exit Code -1073741571
- qExecDirect and SQL Questions
- QExecDirect Second handle issue with SQL Server Drivers
- qFetch with Empty Cell
- qFetch with qBindCol and qGetData
- qGetData 50 columns limit
- qLastCode to Check these SQL Return Codes
- Read Information from Lotus Notes
- Retrieving data after a SQL JOIN
- Return Codes in ODBC Extender
- s0022 error from SQL Server Driver
- Specify SQL Server Password in qConfigData
- SQL Server SELECT SUM Statement
- SQL SUCCESS WITH INFO
- Syntax for Insert Into Access
- Updating ODBC.INI File over the Network
- Using WildCards in an ODBC SQL Statement
Can't find the information you are looking for here? Then leave a message over on our WinBatch Tech Support Forum.
Execute an Oracle stored procedure
Keywords: Execute Oracle stored procedure
Question:
I am using Winbatch with SQL server, and it works fine. Now when I try to do the same with Oracle 7.3 it fails. The connection to the database works fine, but when I try to execute a stored procedure, I receive an "Invalid SQL command" error message.Here is part of my code :
SqlTxt = "execute tstproc('ocadm')"
retcode = qExecDirect(hstmt, SqlTxt)
the retcode is -1 and the message returned by qError(hstmt, 2) is :
37000 [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-00900: Instruction SQL invalid.
When I type the same command : execute tstproc('ocadm') with SQL worksheet or SQL + 3.3, it works fine
Any idea ?
Answer:
The Error message seems to be saying the Oracle driver doesn't recognize that command.You mentioned you are trying to execute a stored procedure I wonder if it has anything to do with the quotes. Maybe the stored procedure requires double quote instead of the single quotes you specified.
Also instead of the word 'execute', try {call stored_procedure).
SqlTxt = '{call tstproc("ocadm")}'
retcode = qExecDirect(hstmt, SqlTxt)
Follow up:
Thanks, you're right it is a stored procedure, it works with the{call tstproc('ocadm')}
Article ID: W14538
Filename: Execute an Oracle stored procedure.txt
File Created: 2001:01:29:14:10:44
Last Updated: 2001:01:29:14:10:44