Home » SQL & PL/SQL » SQL & PL/SQL » how to write the local procedure (Oracle, 10g, windows XP)
how to write the local procedure [message #332570] Wed, 09 July 2008 00:57 Go to next message
jyothsna1612
Messages: 68
Registered: June 2008
Member
Hi
I'm getting the error in the following local procedure
What changes to be done in this procedure
PROCEDURE P_INS
     (X  NUMBER)
IS
BEGIN
  INSERT INTO T_EX1
  VALUES     (1);
END;

The error is:

procedure p_ins(x number) is
*
ERROR at line 1:
ORA-00900: invalid SQL statement


Thank you
Re: how to write the local procedure [message #332574 is a reply to message #332570] Wed, 09 July 2008 01:05 Go to previous messageGo to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
Follow the link:

http://www.adp-gmbh.ch/ora/sql/create_procedure.html

Re: how to write the local procedure [message #332576 is a reply to message #332570] Wed, 09 July 2008 01:06 Go to previous messageGo to next message
sarwagya
Messages: 87
Registered: February 2008
Location: Republic of Nepal
Member
By the way, couldn't you use google to find it yourself??
Re: how to write the local procedure [message #332581 is a reply to message #332570] Wed, 09 July 2008 01:13 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL Reference, CREATE PROCEDURE
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Regards
Michel
Previous Topic: Hi Everyone
Next Topic: execute order
Goto Forum:
  


Current Time: Fri Dec 09 19:19:58 CST 2016

Total time taken to generate the page: 0.10417 seconds