Search results for query: *

Hi all,<br><br>I think this can be useful: If you trying to call stored<br>procedure from the After Report trigger it will not gonna<br>work! User Before Trigger and it doesn't metter if you <br>call procedure directly or thru SRW.DO_SQL .<br><br>Cheers,

I found out that it is also possible to do that from utl_file package using the same functions.<br><br>Thank you !!!

Hi,<br><br>I'm trying to export the result of my SELECT<br>statement into .txt file. Can anybody gave any hint how to do that ?<br><br>Thanks

I found it ! When ever you want to pass single quotas as a part of the string,<br>you have to enclose everything you want to pass with two single quotas at<br>the beggining and at the end. Greg, thank you for your time and effort.<br><br>Cheers

Hi,<br><br>In formula column, I'm trying to build Select statement. Where clause of that statement depend on the value in the placeholder column. My problem is that I have to enclose that value with single quotes (because my column in the database is Varchar).<br>Is anybody have any good idea?<br>

Hi,<br>In Oracle application, in OEXCPVAL module, exist this SELECT statement:<br>SELECT COUNT(*)<br>INTO issue_message<br>FROM SO_LINES l<br>WHERE l.link_to_line_id=n_line_id;<br><br>I need to know what is n_line_id. I think this is the variable where is stored one of the values from line_id...

Hi Eduard,<br><br>Yes, It work. It work perfectly. I taught that I can change the values of the user parameters the same way as in forms, but it doesn't work that way. Thank you again, and if I can help you with something, please let me know.<br><br>Dragan

Hi,<br>I have to setup some user parameters when<br>my report print certain row first time.<br>I cannot use format trigger for that. Is <br>anybody have an idea how to solve this ?<br><br>Thanks