Home » SQL & PL/SQL » SQL & PL/SQL » INSERT DATA USING PROCEDURE IS POSSIBLE (merged)
INSERT DATA USING PROCEDURE IS POSSIBLE (merged) [message #227939] Fri, 30 March 2007 05:32 Go to next message
sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore
Member


c:\>sqlplus /nolog @c:\one.sql

I have one.sql file below like this

*****************************************
CONN tuser/tuser@krishna10g

PROMPT 'PLEASE ENTER THE IP ADD"
PROMPT_VAR = &&IPADD;
PROMPT 'ENTER MAIL ID'
PROMPT_VAR = &&MAILID;

CREATE TABLE TESTTAB3(IPADD VARCHAR2(100),MAILID VARCHAR2(100));
/
CREATE OR REPLACE PROCEDURE TESTPROC3
AS
BEGIN
INSERT INTO TESTTAB3 VALUES(&&IPADD,&&MAILID);
END;
*************************************************
After running the script I getting error like this

Warning: Procedure created with compilation errors.

what was the problem please help me

Thanks in Advance
Re: why is problem "Warning: Procedure created with compilation errors." [message #227940 is a reply to message #227939] Fri, 30 March 2007 05:33 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
type show errors
Re: why is problem "Warning: Procedure created with compilation errors." [message #227942 is a reply to message #227940] Fri, 30 March 2007 05:56 Go to previous messageGo to next message
martijn
Messages: 283
Registered: December 2006
Location: Netherlands
Senior Member
Or type "select * from user_errors"
INSERT DATA USING PROCEDURE IS POSSIBLE ? [message #227949 is a reply to message #227939] Fri, 30 March 2007 06:37 Go to previous messageGo to next message
sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore
Member

Hi

I have a Table testtab7 and having columns (ipadd varchar2(100),mailid varchar2(100))

I trying to insert values using procedure not happing why?

this was the my procedure

Note :Porcedure running with out errors

***************************************************


CREATE OR REPLACE PROCEDURE TESTPROC7
AS
BEGIN
INSERT INTO TESTTAB7 (IPADD,MAILID) VALUES('123.123.123.123','SREE@SREE.COM')
END;
****************************************************



Thanks in Advance
SreenivasaRao.Ponguru
Re: INSERT DATA USING PROCEDURE IS POSSIBLE ? [message #227950 is a reply to message #227949] Fri, 30 March 2007 06:41 Go to previous messageGo to next message
Cthulhu
Messages: 381
Registered: September 2006
Location: UK
Senior Member
I don't see any reason why it shouldn't work. Did you do a commit after running it ?
Re: INSERT DATA USING PROCEDURE IS POSSIBLE ? [message #227951 is a reply to message #227949] Fri, 30 March 2007 06:41 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
And did you commit?

Laughing Sorry, Cthulhu.

MHE

[Updated on: Fri, 30 March 2007 06:42]

Report message to a moderator

Re: INSERT DATA USING PROCEDURE IS POSSIBLE ? [message #227957 is a reply to message #227949] Fri, 30 March 2007 07:51 Go to previous messageGo to next message
joy_division
Messages: 4643
Registered: February 2005
Location: East Coast USA
Senior Member
Did it "compile" without and errors or "run" without any errors? Creating a procedure does not execute it.

Cut and paste your session.
Re: INSERT DATA USING PROCEDURE IS POSSIBLE ? [message #227970 is a reply to message #227949] Fri, 30 March 2007 08:36 Go to previous messageGo to next message
sponguru_dba
Messages: 51
Registered: May 2005
Location: Bangalore
Member

Hi

Cthulhu and Maaher


Sorry I did a mistake ,i forgot to run procedure

Now it is fine


thanks a lot Cthulhu and Maaher

Re: INSERT DATA USING PROCEDURE IS POSSIBLE ? [message #227972 is a reply to message #227970] Fri, 30 March 2007 08:41 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Uh Oh
Re: INSERT DATA USING PROCEDURE IS POSSIBLE ? [message #227973 is a reply to message #227972] Fri, 30 March 2007 08:42 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member


Quote:
joy_division >>>
Creating a procedure does not execute it.


great guess............. Razz

[Updated on: Fri, 30 March 2007 08:48]

Report message to a moderator

Previous Topic: round
Next Topic: DBMS_SCHEDULER
Goto Forum:
  


Current Time: Thu Dec 08 21:55:03 CST 2016

Total time taken to generate the page: 0.15448 seconds