Prev: FRM-40508: Oracle error: unable to insert record
Next: Freelists and Freelist Groups
From: Maga via DBMonster.com on 15 Nov 2005 14:56
Hi everyone,

I have in the Data Block Trigger ON-SEQUENCE-NUMBER

Begin
IF :Global.Using_Transactional_Triggers = 'TRUE' THEN
User_Exit('orderid seq=MEDORDER_ID');
ELSE
Generate_Sequence_Number;
END IF;
END;


and, in the Initial Value property of the item that I need assign this
sequential number
I add the following sentence

:SEQUENCE.sys.medorder_id.NEXTVAL

when I use the form, the number increment but this error appears
FRM-40815: Variable Global.using-Transactional-Triggers does not exist

I obtain this instruction using the help of Forms, I don't know if make the
best use of this method.

My goal when I use this method was use the sequence created to increment
automatically an ID number.

Thanks,
Maga

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200511/1
From: Maga via DBMonster.com on 16 Nov 2005 12:11
I'm use Forms 9i. I did that you suggest, but have problem because on
compilation a message said 'sequence_name.NEXTVAL' must be declared (oviusly
with the name of my sequence), when I declare,follow with tha same problem. I
don't have expecience programming PL/SQL, I don't know if I do bad script.

declare
sequence_name.NEXTVAL number(10);
begin
SELECT sequence_name.NEXTVAL INTO variable FROM dual;
end;

***The error is the dot(.), constant exception
and I use,

declare
sequence_name number(10);
begin
SELECT sequence_name.NEXTVAL INTO variable FROM dual;
end;

**** The error is Invalid reference to variable

I wrote this statement on the Trigger of the Block where reside the variable
that I whant affect.

Thanks,
Maga

DA Morgan wrote:
>> Hi everyone,
>>
>[quoted text clipped - 25 lines]
>> Thanks,
>> Maga
>
>What is it you are trying to do with what version of Forms?
>
>Why not SELECT sequence_name.NEXTVAL INTO variable FROM dual?

--
Message posted via DBMonster.com
http://www.dbmonster.com/Uwe/Forums.aspx/oracle/200511/1
 | 
Pages: 1
Prev: FRM-40508: Oracle error: unable to insert record
Next: Freelists and Freelist Groups