PROBLEM CALLING FUNCTIONS WHICH ALL WORKED WHEN THEY WERE PROCEDURES
Date: 1996/10/26
Message-ID: <54s03l$kg8_at_mtinsc01-mgt.ops.worldnet.att.net>#1/1
I USE THE FOLLOWING TEXT FILE (TEST_FUNCT) TO CALL A FUNCTION USING THE
PERSONAL ORACLE7 FOR WIN95.
DECLARE
RECV_NUM NUMBER;
RECV_NUM := FUNCTION_NAM(FUNCTION PARAMETERS);
/
COMMAND, ORACLE SENDS BACK A COMMAND THAT IT WAS LOOKING FOR SOMETHING
ELSE WHEN IT ENCOUNTERED THE "=" SIGN. WHEN I "START C:\FUNCTION_NAM" I
GET A MESSAGE THAT THE FUNCTION WAS PROPERLY CREATED. I ORIGINALLY HAD
THE FUNCTIONS AS PROCEDURES AND THEY ALL WORKED. NO I WANT TO RETURN
ERROR CODES AND NEED THEM TO BE FUNCTIONS. I KNOW HOW TO DO THE SAME
THING WITH PROCEDURES I JUST WANTED TO TRY IT AS A FUNCTION. THERE MUST BE
SOMETHING I AM OVERLOOKING SUCH AS HOW TO CALL THE FUNCTION. TO CALL
PROCEDURES I USED THE "EXECUTE" COMMAND. IS THERE SOMETHING LIKE THIS FOR
FUNCTIONS?
Received on Sat Oct 26 1996 - 00:00:00 CEST