Results 1 to 2 of 2

Thread: Pls-00103:

  1. #1
    Join Date
    Oct 2002
    Posts
    78

    Unanswered: Pls-00103:

    Hai

    I got the below error when creating procedure.I follwoed like this



    create or replace type address1 as object(address varchar2(200),
    city varchar2(20),
    state varchar2(10),region varchar2(10),country varchar2(10))


    create table cust(no number primary key ,name varchar2(20),person address1);


    create sequence cust_seq start with 1 maxvalue 100 nocycle;


    SQL> create or replace procedure cust_p(name varchar2,add varchar2,
    2 city varchar2,state varchar2,region varchar2,country varchar2) as
    3
    4 begin
    5 insert into cust(no,name,person(address,city,state,region,coun try)) values
    6 (cust_seq.nextval,name,add,city,state,region,count ry);
    7 end;
    8 /

    Warning: Procedure created with compilation errors.

    SQL> show err
    Errors for PROCEDURE CUST_P:

    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    5/32 PLS-00103: Encountered the symbol "(" when expecting one of the
    following:
    . ) , @


    Thanks in advance
    mohan
    5/67 PLS-00103: Encountered the symbol ")" when expecting one of the
    following:
    * & - + ; / at mod rem return returning <an exponent (**)>
    and or || year DAY_

    Thanks in advance
    mohan

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: Pls-00103:

    The correct syntax is:

    insert into cust(no,name,person) values
    (cust_seq.nextval,name,address1(add,city,state,reg ion,country));

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •