4 Replies Latest reply: Dec 1, 2013 4:15 PM by rp0428 RSS

    Having trouble in SQL dev with a procedure.

    Xev Bellringer

      Hey guys, Having trouble with the.following Pl SQL procedure. Is this code wrong?

       

      create table zed ( z varchar2(30);

       

       

      declare

      procedure thisway1 (p_data in varchar2 )

      is

      begin

                  execute immediate

                   'insert into zed(z) values(:z)'

                    using p_data;

                     end thisway1;

       

      ok, ive tried over and over, what is missing from this code?

      Its from a book, so its supposed to work...