Jump to content


cdi_rajesh

Member Since 10 Mar 2003
Offline Last Active Private
-----

Topics I've Started

Global Logic - SQL

03 August 2006 - 08:09 AM

Hi,

Never got this before and kind of strange i am facing a problem.

When i try to execute the below statement using global logic. I am getting an error saying "015 - SUBSCRIPT VALUE NOT WITHIN RANGE OF DIMENSION - L -0.235023=0245024=02 TEST ORA-06550: line 1, column 47: PLS-00103:".

When i comment out the DECLARE statment and hard code the parameter values. The function works fine, but with DECLARE i am having problem.


Global Logic contains below statements:

P PARMS($_ACTION)

$_CURFUNCT = 'ABC'
$_ACTION = 'ADD'
$_LINK_FUNCTION = 'MENU'

SQL
DECLARE
v_action VARCHAR2(8) := :$ACTION;
v_curfunct VARCHAR2(8) := :$CURFUNCT;
v_link_function VARCHAR2(8) := :$LINK_FUNCTION;
BEGIN
performance_logging_package.write_pro4_log(v_action, v_curfunct, v_link_function);
END;
ENDSQL


Any help is appreciated

Thanks

Proiv Training

15 May 2006 - 06:14 PM

Hi All,

I am willing to offer my services to those who are intereted in learning Proiv in India. But this wouldn't come for free. Surely i would charge my fee. So those who are interested, do get in touch with me.

Regards