solve ORA-6550

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

Pveena20 pointsBadges:

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...

SQL Server Ask the Experts2,585 pointsBadges:

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!

Nikkipom795 pointsBadges:

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 )

PramodSR35 pointsBadges:

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...

VPL100 pointsBadges:

Return multiple rows from a stored procedure in Oracle

I'm looking to create a stored procedure, with one argument, which will return different sets of records (that all depends on the argument). What would be the best way to do this? Would it be possible to call it from a plain SQL?

ITKE1,146,245 pointsBadges:

Creation of object table inside a stored procedure in Oracle

I want to create a object type table inside a stored procedure for holding record fetch from a cursor and return result set to a sys_refcursor for c#

RajivMohanty15 pointsBadges:

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...

Ala10ala15 pointsBadges:

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...

SQL Server Ask the Experts2,585 pointsBadges:

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...

Fishman15 pointsBadges:

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 of the...

BrentSheets6,950 pointsBadges:

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...

BrentSheets6,950 pointsBadges:

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...

Hanrahul85 pointsBadges:

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.

VPL100 pointsBadges:

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...

Shaksing5 pointsBadges:

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 =...

Hermes6835 pointsBadges: