how to solve ORA-6550 PLS-00201 when trying to run a stored procedure in Oracle10g
We have a linked server from SQL to Oracle and successfully ran Oracle stored procedures from SQL to insert data. I am attempting to run a different SP that returns data but can’t seem to get the syntax correct. My call includes a couple of date fields as parameters and a cursor is returned. Are [...]
Using a linked server I can’t seem to execute an Oracle SP from SQL. The Oracle SP requires 5 parameters and returns a cursor to a record set. The error I get suggests a syntax issue. OLE DB provider “MSDAORA” for linked server “PASSRPT” returned message “Syntax error in {resultset…} ODBC Escape.”. Do I need [...]
I am using Oracle 8.1.5 with MS Dot NET 2005 on Windows XP with service pack 2. When I am sending data through a stored procedure, it is giving the error of “TNS:12571 : packet write failure” but it’s adding record in table, but truncated data in some columns and no data in the rest [...]
We wrote a stored procedure, where we are passing input as VARCHAR2. And passing 73 characters string as input. Till here its fine. After giving few extra characters above this, it’s giving the error: ORA-06502: PL/SQL: numeric or value error ORA-06512: at “stored procedure name”, line 114 ORA-06512: at line 1″ ORA-06502: PL/SQL: numeric or [...]
I have procedure iven below Output of the procedure below is multiple rows but i am getting only 1st row how to use concept of SYS_REFCURSOR over here CREATE OR REPLACE procedure Vishal_PROC_sp1 (kpiid in number, val1 out varchar2, val2 OUT Number) as cursor c1 is select kpimainid,sysdate,selectstmt,clause,to_char(sysdate,’MON’) month,cautionmax,cautionmin from kpimain where kpimainid = kpiid; [...]
I’m converting an application from Delphi3 to Delphi5. I have some doubts about Stored procedures. Delphi calling stored procedures in oracle.some parameters value are set as input and passed to oracle. stored procedure in oracle returns some value. in my delphicode when the application reaches the procedure ‘execproc’ an error is thrown up. The error [...]
I need to call an Oracle stored procedure from SQL Server. The stored procedure is written in ANSI SQL. ORCL is my linked server. I am calling ORCL.USER.PROCEDURE P1, P2, P3 and I am getting this error: Could not execute procedure ‘PROCEDURE_NAME’ on remote server ‘ORCL’. [OLE/DB provider returned message: One or more errors occurred [...]
how to match the datatype of the field that is in database and the datatype of the variable that holds the value of the returned value from database using stored procedure.
‘ALTER INDEX ‘ || C_Indices.INDEX_NAME ||’ REBUILD ‘; ‘ALTER INDEX ‘ || C_Indices.INDEX_NAME || ‘ REBUILD ONLINE COMPUTE STATISTICS’; In my stored procedure , i am reconstructing or you can say re-building the tables and table name is the input parameter to the procedure. In middle of the code , i am using execute immediate [...]
I have a vb6 – RDO code that works ok with Oracle8, recently there was an upgrade to Oracle 10g enterprise. Now I get the error 40041 -> Object Collection: Couldn’t find item indicated by text. 1110 lstrSQL = "{call Pyramid.Load_Tables(?, ?, 0)}" 1120 Set lrdoQ = vConexionDatos.MiDataBase.CreateQuery("ProcessTables", lstrSQL) 1130 lrdoQ.rdoParameters(0).Direction = rdParamInput 1140 lrdoQ.rdoParameters(0).Type [...]
Can u please tell me how to call a oracle stored procedure that accepts 2 in parms and returns a Ref cursor as out parameter exmple: CREATE OR REPLACE PROCEDURE GetReportData ( Id1 IN NUMBER, Id2 IN NUMBER, resultSet OUT sys_refcursor )
Is it possible to call a SQL Server 2005 stored procedure from Oracle? If the sp is called get_item_desc and has one input parameter (item_id), what might this call look like? Any help most appreciated!
I’m trying to create a dataset from an oracle stored proc.The stored proc takes in parameters and generate multiple rows through a OUT ref cursor. BUT when I create a dataset and run it I get ONLY one single row. My reports need to show data for multiple persons(multiple rows).Some times when I run the [...]





