| RESETTING SEQUENCE VALUE [message #351851] |
Fri, 03 October 2008 08:14  |
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 #351996 is a reply to message #351980] |
Sat, 04 October 2008 15:05  |
 |
Littlefoot
Messages: 21823
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
