Dev 2K - Forms Problem
Date: 1997/07/09
Message-ID: <33C3E364.51F7C7C2_at_ctp.com>#1/1
HELP!!!!! I am trying to do something so simple and straight forward, I can't figure out why it won't work. Here is a sample of what I am trying to do:
SELECT SALESREP
INTO :CUSTOMER_BLOCK.SALESREP
FROM SALES_REP_TBL
WHERE SALES_REP_TBL.LASTNAME = :CUSTOMER_BLOCK.SALESREP_NAME;
It compiles fine, but never finds anything. When I go into the
debugger, CUSTOMER_BLOCK.SALESREP_NAME has the correct information in it
and it is the correct data type, but when I type the statement directly
at the PL/SQL> prompt, I get the following error:
PDE-PUP001 ORA-00933: SQL command not properly ended.
Any ideas?
thanks,
dan
Dan Stern<dstern_at_ctp.com> Cambridge Technology Partners
voice: 617.374.8400 304 Vassar St.
fax: 617.374.8300 Cambridge, MA 02139 USA
http://www.ctp.com
Received on Wed Jul 09 1997 - 00:00:00 CEST