Search results for query: *

Hi, Please refer to Note:1011625.7 at metalink. You need to create a macro & call this macro within your Program from the Form. Regards Himanshu

Hi, On your Key - create record trigger write: Last_record; Create_record; Regards Himanshu

Hi, Whatever code you have written to Populate the Sec name list, write it again on the the trigger when-list-changed of List item deptname & add the where clause to it accordingly. i.e. when deptcd=:blockname.deptcd. HTH Regards Himanshu

Yes Sem, Both were launched by same user, which also happens to be the owner of all the objects used in both Processes. Yes Sbix, the this is funny & I have no answer to it,why this is happening. I have given the workaround to my team and the process is running fine but I am keen to find out...

Dear Sbix, There is no contetnion of temp tablespace. Sorry for confusing post,by temp table I mean a Database table only which I named as temp. Also please go through the post carefully,I am facing the problem when we use cursors. Do let me know if you have any idea about it. Regards Himanshu

Dima, We have tried both TEXT_IO from forms & UTL_FILE from stored procedures. I repeat once again that there is no problem with writing of CSV file. Once the data is populated in the Temp table(as we are currently doing) it takes less than a second to write the file. By using insert into temp...

SDMY, Again there is a syntax error in your code. Instead of writing FILEHANDLER:=UTL_FILE.FOPEN(L_DIR||abc.sql,'W'); You are supposed to write FILEHANDLER:=UTL_FILE.FOPEN(L_DIR,'abc.sql','W'); Also please ensure that directory 'c:/sample' exist for the utl_file parmaeter in your DB...

Dima, Thanks for the valuable input. I have traced both the sql's & both of them have same execution plan.The only difference in case of PL/SQL you have context switching which is not very high. Both the SQL's used on SQL prompt as well as in Cursor are same & there in no datatype difference...

Dear All, My team is facing a problem. They have made a stored procedure which fetches data in to a Cursor and then writes it into a CSV file. The query has been checked & it is fully optimized. When executed on sql prompt it fetches data in milliseconds. The query uses UNION ALL clause & has...

Hi sdmy , As you have not implemented the code the way I have written it it is giving you errors. Your code L_FINAL_STR:=' SELECT L_SQL_TEXT FROM ((SELECT L_SQL_TEXT FROM I.rst MINUS SELECT L_SQL_TEXT FROM I.cst@Link2 UNION (SELECT L_SQL_TEXT...

Hi, In order to create a script for your self for each table you can simply run the following procedure. Chnage the YTL_DIR path as per the settings of your database. create or replace procedure myseq is CURSOR C1 IS SELECT TABLE_NAME FROM USER_TABLES; Cursor First_Table_Cur(P_TAB VARCHAR2)...

Hi, You would require a Database link between the two databases. and then issue the query from target db to source db(e.g. dbn200): create table a as select * from from schemaname.tablename@datbaselinkname; HTH Regards Himanshu

Hi, Please refer to Note:95518.1 at Metalink. HTH Regards Himanshu

Hi, You can get your Stored Procedure & Functions's Text from view USER_SOURCE or DBA_SOURCE or ALL_SOURCE. Select Text from user_source where NAME ='MY_PROC'; HTH Regards Himanshu

Hi, Tyb I do not see any problem with this. Check what is the formula you have written for calculation. Check if the 2nd item which has value of 66.67 is rounded off to 67 otherwise the result should be perefect. You may chek by running followin query also on sql prompt. SQL> select...

Hi, You may use ORA_FFI or DDE package to run any external application or Program. HTH Regards Himanshu

Hi, Make use of Project Builder to make installable file for your application. HTH Regards Himanshu

Hi, This code will not work if you use a Bind variable instead of a harcoded value. If you wish to use a Varibale then declare the cursor , open it & then use the values fetched by the cursor. HTH Regards Himanshu

Hi, Hudo, please read through the Online help thoroughly. It has following Options: SET_CANVAS_PROPERTY (canvas_id CANVAS, property NUMBER, value VARCHAR2); SET_CANVAS_PROPERTY (canvas_id CANVAS, property NUMBER, x NUMBER); SET_CANVAS_PROPERTY (canvas_id...

Hi, Hudo, please read through the Online help thoroughly. It has following Options: SET_CANVAS_PROPERTY (canvas_id CANVAS, property NUMBER, value VARCHAR2); SET_CANVAS_PROPERTY (canvas_id CANVAS, property NUMBER, x NUMBER); SET_CANVAS_PROPERTY (canvas_id...