Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to execute a procedure and function at command line?

655810Aug 22 2008 — edited Aug 25 2008
I tried to execute the following function at command line.
CREATE OR REPLACE FUNCTION FN_IS_SYSDATE_TICKING
RETURN BOOLEAN
IS
ls_value VARCHAR2(100) DEFAULT 'NONE';
BEGIN
SELECT value
INTO ls_value
FROM V$PARAMETER
WHERE name = 'fixed_date';

IF ls_value = 'NONE' THEN
RETURN TRUE;
ELSE
RETURN FALSE;
END IF;
EXCEPTION
WHEN OTHERS THEN
RETURN TRUE;
END FN_IS_SYSDATE_TICKING();

At Command Line, I entered

var v1 BOOLEAN;
exec :v1 := RSSC.FN_IS_SYSDATE_TICKING();
print v1;

It is giving boolean is not declared.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2008
Added on Aug 22 2008
10 comments
971 views