Home » Developer & Programmer » Forms » RESETTING SEQUENCE VALUE
RESETTING SEQUENCE VALUE [message #351851] Fri, 03 October 2008 08:14 Go to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
Hi,

I have one Sequence number which I need to reset that in table trigger. I tried drop and create it on Trigger but oracle does not accepted and I got error PLS-00103. Please advice.

Thanks
Re: RESETTING SEQUENCE VALUE [message #351939 is a reply to message #351851] Fri, 03 October 2008 15:34 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
How exactly did you try to do that? Code would certainly help us to help you.

Now, a blind shot: did you research use of the FORMS_DDL built-in?
Re: RESETTING SEQUENCE VALUE [message #351980 is a reply to message #351851] Sat, 04 October 2008 07:53 Go to previous messageGo to next message
mhakimjavadi
Messages: 37
Registered: July 2008
Member
As I told you I put DROP SEQUENCE and create SEQUENCE in BD table trigger and I got error. Do you know any other way to reseting sequence value in table trigger?
Re: RESETTING SEQUENCE VALUE [message #351996 is a reply to message #351980] Sat, 04 October 2008 15:05 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
mhakimjavadi
As I told you ...

Yes, you have. And I didn't understand what you've said. That's why I asked you to post code you have used. Not fairy tales about what you've done, but exact code. As stated in the OraFAQ Forum Guide, "Posting guidelines" section, "Practice" subsection:
the Guide
Show us what you did (if you tried it yourself) and how Oracle responded (COPY & PASTE your SQL*Plus session), including errors and/or why the result is not what you want.
Do not describe, explain or report - show us!


What is a "BD table trigger"? If it was a typo and you meant (guessing again) a "DB" (as database) trigger, it would make sense. In that case, see the way EXECUTE IMMEDIATE is to be used.

On the other hand, if the above is correct, what does your question do in the Forms forum (while it should have been asked in the SQL & PL/SQL one)?

So: if it is a forms question, see FORMS_DDL. If it is PL/SQL question, see EXECUTE IMMEDIATE. If it is something else, well, what is it?
Previous Topic: Image browser
Next Topic: using POST in trigger
Goto Forum:
  


Current Time: Thu Dec 08 23:58:32 CST 2016

Total time taken to generate the page: 0.21651 seconds