Oracle Reports (MOSC)

MOSC Banner

CONCURRENT ERROR

edited Apr 23, 2013 12:45AM in Oracle Reports (MOSC) 3 commentsAnswered

HI all

Will you please so kind and help me on this issue:'

ERROR:

ORACLE error 6550 in FDPSTP 

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:

PLS-00201: identifier 'MTNVECO' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored .

PACKAGE:

CREATE OR REPLACE PROCEDURE APPS3_MTNAOL.MTN_VENDOR_COUNT

                          ( p_from_date in date ,

                            p_to_date in date ,                         

                            errbuf  OUT VARCHAR2,

                            retcode OUT NUMBER

                           ) AS

P_ORG_ID                NUMBER;

v_count                 number;

-- GET ALL Virtual Trade Customers  --

CURSOR c1 IS

SELECT abc.vendor_name,abc.enabled_flag,assa.vendor_site_code,assa.inactive_date, count(*) "Number of Transactions"

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center