Pl/sql prompt to continue9/27/2023 Once you've done this it will keep the value until you end the session or undefine it: New 5: dbms_output.put_line ( 'You entered: ' || '' ) ĭefine the variable before calling it. Old 5: dbms_output.put_line ( 'You entered: ' || '&1' ) Pass an empty string as arguments to the script:ĭbms_output.put_line ( '#1 cannot be null' ) ĭbms_output.put_line ( 'You entered: ' || '&1' ) ![]() To overcome this there are a couple of methods you could use: If they're not already define it'll prompt you. ![]() To use them Oracle needs to know their values. When you "set define on", Oracle interprets ampersands as substitution variables.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |