PL/SQL (MOSC)

MOSC Banner

PLS-00225: subprogram or cursor 'C_INTERFACE_RECORDS' reference is out of scope

edited Mar 5, 2018 4:01AM in PL/SQL (MOSC) 4 commentsAnswered

Hi All,

I keep getting below errors on the Package Body when Compiled.Not sure what is missing

Errors:

  • Error(131,51): PLS-00225: subprogram or cursor 'C_INTERFACE_RECORDS' reference is out of scope
  • Error(264,14): PLS-00306: wrong number or types of arguments in call to 'LOG'
  • Error(384,7): PLS-00306: wrong number or types of arguments in call to 'LOG'

Code:

CREATE OR REPLACE PACKAGE BODY BBB_COGS_DUP_REV

AS

   PROCEDURE xxbb_insert_gl_interface (errbuf  OUT VARCHAR2,

                                      retcode OUT NUMBER)

   IS

      v_currency_code     VARCHAR2 (30);

  v_coa_id            VARCHAR2 (50);

      v_period_name       VARCHAR2 (50);

      v_ledger_id         NUMBER;

      v_insert_err_flag   NUMBER;

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