Search results for query: *

Cheers sem, I had to play around with it abit, but your advice put me on the right track. Solution: Declare .. Quote_ varchar2(10); v_log_status VARCHAR2(1); BEGIN Quote_ := ''''; v_log_status := :DELETE_BLK.ls; FORMS_DDL('BEGIN DELETE FROM ' ||sql_statement_ ||' WHERE log_status =...

Forget that last bit, I have got Forms_DDL to delete on Number, Thanks alot sem for all your help. I didnt notice because I forgot to excute_statment to refresh my screen, opps! I still need to work out how to put quotation marks into a string so I can delete on log_status. I think you can...

I noticed that, when tryed experimenting with: cursor_hndlr := DBMS_SQL.OPEN_CURSOR; sql_statement_try := 'Delete from '|| sql_statement_ ||' Where log_status = '||v_log_status; message(sql_statement_try); DBMS_SQL.PARSE(cursor_hndlr, sql_statement_try, 1); update_applied :=...

Is anything else I need to do. As I can compile ok now. But it wont delete. This is my phrasing.. FORMS_DDL('BEGIN DELETE FROM ' ||sql_statement_ ||'WHERE BATCH_LD_ID = '||v_batch_id|| '; END;'); Commit; sql_statment_ is full table name, which I have checked with message('Table in statment...

Cheers Sem, I will give this a try, no-doubt I will be back. Because I am writing reusable componants I have created more development time for myself :) We have Oracle 9i knocking about on the network but getting hold of it is not that easy. So just have to work with the tools ive got I suppose...

Hi, Im using Form Builder in Oralce Developer 6.0 with Oracle 8 Drivers I think.

Hi I writting a procedure that deletes selected log tables from the database. I am trying to use a string which depending on the else-if statment concatanates a different where clause to it. I am trying to write a dynamic procedure because The screen works on 52 different log screens. These logs...

Hi, i'm having some problems with the use of LOV's. The LOV is used in a manual data cross refence screen, where the user selects an item from the LOV which matchs an item to be cross referenced. However, due to the size of data, and the database design, the LOV can take about 3 minuites to...