I have this Oracle SQL View written, but I need a parameter to select the Trx ID, otherwise it runs way too slow. When putting a bind variable in the SQL View and try to run, it returns this error:
ORA-00900 invalid SQL statement
I added the Bind Variable of TRX_ID so the user could enter the
TRX ID when running:
CREATE OR REPLACE VIEW VIEWNAME_V
AND E.ENTITY_NO =:TRX_ID
Could anyone assist me or do you have any suggestions?