Results 1 to 4 of 4

Thread: pls-00103

  1. #1
    Join Date
    Sep 2003
    Posts
    6

    Unanswered: pls-00103

    i always encounter this error :"encountered the symbol "T" when expecting one of the following . ( ) , * @ % & | = - + < / > at in is mod not range rem => .. <an e xponent (**)> <> or != or ~= >= <= <> and or like between || .

    here is my code:

    create or replace trigger nointerest
    before update on mbaccount
    for each row
    declare p mbaccount%rowtype;
    begin
    select * into p from mbaccount where account_type='CRD';
    if p.balance>0 and p.int_rate>0 then
    raise_application_error(-20123, 'credit accounts with positive balances can't earn interests');
    end if;
    end;

    any hints would help
    thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    You have a ' in the second parameter to raise_application_error. Remove it or change it for two single quotes '' (not double quote ") as follows.

    raise_application_error(-20123, 'credit accounts with positive balances can''t earn interests');

    Hth
    Bill

  3. #3
    Join Date
    Sep 2003
    Posts
    6
    thanks for the tip but unfortuately that still didn't work

  4. #4
    Join Date
    Sep 2003
    Posts
    6
    my mistake it did work after all
    thanks for the help.

Posting Permissions

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