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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MERGE - 9i SQL Command

Status
Not open for further replies.
djbjr

djbjr

Programmer
Dec 7, 2001
106
US
Just finished testing the MERGE command on our data warehouse.

WHAT AN AMAZING COMMAND!!!

So quick and eliminates timely PL/SQL.

PROBLEM:

When running the MERGE command twice in the same session I get an error.

QUESTION:

Any clue on how I can refresh my session within a procedure? Our TOOL that we use on our data warehouse holds on to the same oracle session for long periods of time.

Thanks in advance
 
Status
Not open for further replies.

Similar threads

TheLazyPig
  • Locked
  • Question
Merge Into with multiple execution 1
Replies
1
Views
871
carp
carp
Livia8
  • Locked
  • Question
Alternative to "locate" command
Replies
0
Views
892
Livia8
Livia8
Andrzejek
  • Locked
  • Question
Get part of a string with SQL 1
Replies
2
Views
1K
Andrzejek
Andrzejek
Livia8
  • Locked
  • Question
SQL SELECT - where date is null or greater than 2
Replies
9
Views
6K
carp
carp
annie1975
  • Locked
  • Question
sql script in an cron job script failing
Replies
3
Views
491
carp
carp

Part and Inventory Search

Sponsor

Back
Top