niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
· nixdoc.net · man pages · Linux HOWTOs · FreeBSD Tips · Forums
navigation Forum index » Databases » Oracle » Server
FRM-40815: Variable Global.using-Transactional-Triggers does not exist
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
Author Message
Maga
*nix forums beginner


Joined: 11 Nov 2005
Posts: 5

PostPosted: Tue Nov 15, 2005 7:56 pm    Post subject: FRM-40815: Variable Global.using-Transactional-Triggers does not exist Reply with quote

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
Back to top
psoug
*nix forums Guru


Joined: 15 May 2005
Posts: 3488

PostPosted: Wed Nov 16, 2005 6:10 am    Post subject: Re: FRM-40815: Variable Global.using-Transactional-Triggers does not exist Reply with quote

Maga via DBMonster.com wrote:
Quote:
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

What is it you are trying to do with what version of Forms?

Why not SELECT sequence_name.NEXTVAL INTO variable FROM dual?
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)
Back to top
Maga
*nix forums beginner


Joined: 11 Nov 2005
Posts: 5

PostPosted: Wed Nov 16, 2005 5:11 pm    Post subject: Re: FRM-40815: Variable Global.using-Transactional-Triggers does not exist Reply with quote

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:
Quote:
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
Back to top
Google

Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [3 Posts] View previous topic :: View next topic
The time now is Sat Nov 01, 2014 4:23 am | All times are GMT
navigation Forum index » Databases » Oracle » Server
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Postfix + MySQL error: very strange variable %s iWarior Postfix 0 Mon Aug 25, 2008 2:01 pm
No new posts User Environment - export PATH variable paalepu AIX 0 Tue Sep 12, 2006 8:12 pm
No new posts access method "gin" does not exist Kevin Murphy PostgreSQL 0 Thu Jul 20, 2006 4:25 pm
No new posts Qmail / SpamControl => Check if DNS exist ? Phibee NOC Qmail 2 Thu Jul 20, 2006 4:51 am
No new posts how to alias an array with a variable in a loop ? Jack Perl 4 Wed Jul 19, 2006 8:17 pm

Copyright © 2004-2005 DeniX Solutions SRL
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum |  email marketing service
 
Privacy Policy
[ Time: 0.0350s ][ Queries: 16 (0.0054s) ][ GZIP on - Debug on ]