Hi guys,
I am new on here, I have a function in oracle that returns a specific value:

create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete VARCHAR2(50);
BEGIN
(Some code here)

RETURN ASDComplete;
END;
END;

END CTC_ASDGET_SCHED;

So the above basically should return a value eg. 090512,

now in my .sql script (which I execute from a Korn Shell script) I have in Unix I call this function as follows:

SET AUTOPRINT OFF;
VAR VAL VARCHAR2(50);
VAR ASDSCHEDULE VARCHAR2(50);
VAR NAME VARCHAR2(50);
BEGIN
:VAL := MTMREP.CTC_ASDGET_SCHED.FN_ASDSCHEDULE_GET;
:NAME := MTMREP.M01100_MTMIMPORT.P01102_ImportControl(:VAL,'PF');
END;
/
quit;

I'm trying to pass the value which will be stored in (VAL) from the above first function (eg. 090512), I then need to pass this value in the 2nd procedure above called P01102_ImportControl but it still gives me an error.

The procedure P01102_ImportControl is as follows:


PROCEDURE P01102_ImportControl (ASDSchedule IN VARCHAR2, ASDVersion In VARCHAR2) AS
Begin

-- some code

End P01102_ImportControl;

Here is the error:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

ppadev1 SQL> :NAME := MTMREP.M01100_MTMIMPORT.P01102_ImportControl(:VAL,'PF');
*
ERROR at line 3:
ORA-06550: line 3, column 10:
PLS-00222: no function with name 'P01102_IMPORTCONTROL' exists in this scope
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored

Can someone please help me with this or give me some idea how to do this so it works. Thanks in advance.

I don't know much about Oracle or PL/SQL ...
However did find the following, so I hope it helps a little.

ORA-06550: ORA-06550: line <i>string</i>, column <i>string</i>: <i>st...

PLS-00222: PLS-00222: no function with name '<i>string</i>' exists in...

Cheers,
Cameron