solve ORA-6550
how to solve ORA-6550 PLS-00201 when trying to run a stored procedure in Oracle10g

Answer Question   |  August 5, 2011  7:54 AM
error ORA-6550 PLS-00201, ora-6550, Oracle 10g, Oracle 10g administration, Oracle Error Codes, Oracle stored procedures

Oracle SP syntax issues
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 [...]

Answer Question   |  June 5, 2009  2:42 PM
Oracle, Oracle stored procedures, SQL Server, Syntax errors

Executing Oracle stored procedure from SQL server
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 [...]

Answer Question   |  June 4, 2009  7:42 PM
Oracle, Oracle stored procedures, SQL Server

Packet Write Failure error in Oracle 8.1.5
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 [...]

Answer Question   |  May 19, 2009  8:30 PM
Oracle 8.1.5, Oracle error messages, Oracle stored procedures, Packet Write Failure

Oracle stored procedure error with PL/SQL
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 [...]

Answer Question   |  May 14, 2009  4:45 PM
ORA-06502, ORA-06512, Oracle stored procedures, PL/SQL, PL/SQL error messages

How To execute procedure
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; [...]

Answer Question   |  April 30, 2009  7:25 PM
Oracle SQL, Oracle stored procedures, SYS_REFCURSOR

Delphi and Oracle stored procedures
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 [...]

Answer Question   |  January 29, 2009  10:13 AM
Delphi 3, Delphi 5, Delphi error messages, Delphi stored procedures, Oracle stored procedures

Calling an Oracle stored procedure in SQL Server
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 [...]

Answer Question   |  December 29, 2008  7:50 PM
ANSI norm, ANSI SQL, Oracle stored procedures, SQL Server stored procedures

stored procedure in delphi with oracle
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.

Answer Question   |  December 29, 2008  1:50 PM
Delphi, Delphi 5, Oracle, Oracle stored procedures, Stored Procedure variables

ALTER INDEX statement
‘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 [...]

Answer Question   |  December 17, 2008  12:54 PM
ALTER INDEX statement, EXECUTE IMMEDIATE statement, Oracle development, Oracle SQL, Oracle stored procedures, SQL statements, Stored Procedures

VB6 Oracle 10 Stored procedures with parameters
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 [...]

Answer Question   |  December 11, 2008  8:20 PM
Oracle 10g, Oracle error messages, Oracle stored procedures, Oracle upgrades, VB 6, Visual Basic

Call Oracle Store Procedure from Reporting services
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 )

Answer Question   |  September 30, 2008  2:56 PM
Oracle reporting, Oracle stored procedures, REF CURSOR

Calling a SQL Server 05 Stored Procedure from Oracle
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!

Answer Question   |  January 16, 2009  7:20 AM
DBLink, Oracle, Oracle stored procedures, SQL Server 2005, SQL stored procedures, Stored Procedures

Using Oracle 10g Stored proc in SSRS 2005
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 [...]

Answer Question   |  July 14, 2009  1:08 AM
Oracle 10g, Oracle stored procedures, SQL Server Reporting Services, SSRS 2005, Stored Procedures