PL/SQL (MOSC)

MOSC Banner

Stored Procedure in Oracle Financials using a parameter

edited Jul 12, 2011 1:12AM in PL/SQL (MOSC) 15 commentsAnswered
I created pl/sql code in a stored procedure and saved and compiled. I registered the program and executable in oracle financials application 12.0.6. Setup to pass in one parameter from the applsys.fnd_flex_values table (flex_value).

I run the request and receive the following error:

ORACLE error 6550 in FDPSTP

Cause: FDPSTP failed due to ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'NJT_RAIL_FT_BLR_RATES'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

My code is:

CREATE OR REPLACE PROCEDURE "NJT_RAIL_FT_BLR_RATES"
    (old_rate in varchar2)
is
--Declare
-- Declare Local Variables.

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