Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

PRE-INSERT TRIGGER SYNTAX

Status
Not open for further replies.

megatron33

Programmer
Jun 28, 2001
8
GB
Can anyone tell me what is wrong with the folowing line of code :-
av_data_image.blob_type := 'IMAGE';

URGENT - Please Help
 
What is av_data_image.blob_type? What datatype is it?

Without a leading : blob_type must be a variable in a package called av_data_image. If av_data_image is a block, you must preceed with a colon like

:av_data_image.blob_type = 'IMAGE';

If blob_type is a number or date datatype you will also get an error.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top