pls-00049/ View From a Button
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: pls-00049/ View From a Button

  1. #1
    Join Date
    Jul 2005
    Posts
    2

    pls-00049/ View From a Button

    1 I have created one table

    item_master (item_id varchar2(4)
    (sub_item_code varchar2(4)
    (description varchar(100)

    i have created a form using this table and add a button on this form. I wish to view all records of this table (on pressed) using this created button on this form. How to do

    2. I have created two tables
    a.) item_master (item_id varchar2(4)
    sub_item_code varchar2(4)
    description varchar2(100)

    b.) audit_cust (item_no varchar2(4)
    description varchar2(100)
    i have createds a trigger as given below

    create or replace trigger viewall
    before update on item_master
    for each row
    --declare
    --description varchar2(100);
    begin
    insert into audit_cust values (ld.description);
    end;

    when compiling it shows erros. I have tried with both the option i.e removing declare & without removing declare. In both the cases it show erros as

    4/32 PLS-00049: bad bind variable 'OLD.DESCRIPTION'

    pl help

    (navneet)

  2. #2
    Join Date
    Feb 2003
    Location
    Pak
    Posts
    64
    sorry, just deleting.
    Last edited by nametullah; 08-01-2005 at 07:16 AM.
    Always Remember Power is Your.

Posting Permissions

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



Click Here to Expand Forum to Full Width