Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dropping/Recreating Sequences in Stored Procs

Status
Not open for further replies.
jballum

jballum

MIS
Joined
Jul 10, 2000
Messages
161
Location
CA
Are you allowed to drop and then recreate Sequences within a stored procedure?

If not is there a trick to performing this action?

Thanx

JB
 
Sort by date Sort by votes
Yes you can do it; but you need to execute this as dynamic SQL; the syntax for this will obviously differ dependant on the version of Oracle you are using.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

rk68
  • Locked
  • Question Question
Data encryption in Oracle 19c
Replies
0
Views
542
rk68
rk68
TheLazyPig
  • Locked
  • Question Question
Merge Into with multiple execution
Replies
1
Views
1K
carp
carp
annie1975
  • Locked
  • Question Question
sql script in an cron job script failing
Replies
3
Views
666
carp
carp
Livia8
  • Locked
  • Question Question
SQL script to find number of characters allowed in "Description" column of "AP_INVOIC
Replies
5
Views
800
Livia8
Livia8
Andrzejek
  • Locked
  • Question Question
Insert multiple records
Replies
9
Views
2K
mikrom
mikrom

Part and Inventory Search

Sponsor

Back
Top