Code Newbie
News     Forums     Search     Members     Sign Up    

My Code Newbie
Username

Password

Articles/Snippets
ASP Classic
ASP.NET
C
C#
C++
HTML / CSS
Java
Javascript
Linux / BSD
Perl
PHP
Python
Ruby
SQL
VB 6
VB.NET

C.N. Friends
  Planet Rome

Link to Us!
Code Newbie
  Code Newbie
    forums
Go Back   Code Forums > Application and Web Development > Everything SQL ( MySQL, MSSQL, DB2, Postgre, Oracle, etc...)
User Name
Password

Reply
 
LinkBack Thread Tools Display Modes
Old 02-23-2006, 07:52 PM   #1 (permalink)
ashok rajagopal
Registered User
 
ashok rajagopal's Avatar
 
Join Date: Sep 2005
Posts: 20
ashok rajagopal is on a distinguished road
SQLplus errors - oracle

I'm executing a query from my shell script thru sqlplus. following is the body.

select * from job_control where job_id ='1'
insert into job_control values ( ................................)
commit;
WHENEVER SQLERROR EXIT SQLCODE;
exit;


I just wanna know of which statement be the error message.
of the insert query,
or the commit ?

or both ?
__________________
ashok rajagopal is offline   Reply With Quote
Old 04-23-2007, 03:05 AM   #2 (permalink)
codenewbieBA
Recruit
 
Join Date: Jan 2007
Posts: 10
codenewbieBA is on a distinguished road
Hi,

What error message are you getting?

what is that WHENEVER SQLERROR ?

I am not getting.
Let me know.
__________________
codenewbieBA is offline   Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Oracle Offers Free Database technobard Code Newbie News 0 10-31-2005 06:48 AM
Php with Oracle yasir.younus PHP 1 11-17-2004 07:16 PM
php & oracle.. viruz PHP 3 09-08-2004 11:07 AM
Beginning SQL sequences using PostgreSQL and Oracle jeffro SQL 1 02-03-2004 08:32 AM
Oracle CEO Debates PeopleSoft Bid redhead Code Newbie News 0 07-06-2003 04:11 AM


All times are GMT -8. The time now is 08:09 PM.


Powered by vBulletin Version 3.6.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.0.0 RC8





Copyright © 2000-2006, Milano Interactive
Web Hosting provided by Portal 360 Web Hosting
Open Circle