Use execute immediate 'select .......' instead to build ur dynamic sql and execute it ,
see this for more info on execute immediate statement :
http://download.oracle.com/docs/cd/B..._statement.htm...
asp2
Last Activity: May 5 '10, 10:20 PM
Joined: Dec 11 '08
Location:
-
you can "run" a macro using client-side client_ole2 code , use:
args:=client_ol e2.CREATE_ARGLI ST;
client_ole2.ADD _ARG( args, V_MACRO_NAME );
client_ole2.INV OKE( Application, 'RUN' ,ARGS );
client_ole2.des troy_arglist(ar gs);Leave a comment:
-
try testing the connection first before going to step 2 :
you should enter into infinite loop (or until defined time) until connection replies ...
try something like this :
declare
v_c number := 0;
begin
loop
begin
select 1 into v_c from dual where rownum = 1 @(db_link);
if v_c = 1 then exit ; end if;
exception when no_data_found then null...Leave a comment:
-
according to my search results ,
if the SELECT statement does not have a specific ORDER BY , then there's no way you can determine exactly in which order data will come .
try it yourself on any table and select from that table once witout an order by , and else with order by rowid , and you will see yourslelf ..
the best way is to add an order by in the program you are using
you can at least...Leave a comment:
-
you can get rid of this duplication , if you really need this , by creating a new table having columns ID , EMP-SUM ,
and remove EMP-SUM column from this table ...
hope this helps ...Leave a comment:
-
I think you should give Sizes for your VARCHAR2 columns ....
e.g. VARCHAR2(30)Leave a comment:
-
hope this helps
use this query :
hope this helps .....Leave a comment:
-
I haven't solved the problem I have overcomed it , by handing errors with :
cursor%NOTFOUND and sqlcode <> 0Leave a comment:
-
I had already done so ... same thing happens :)
N.B. crime_code is the table's primary key :D...Leave a comment:
-
asp2 started a topic Cursor that is supposed to return one value Returns duplicated values of same rowin OracleCursor that is supposed to return one value Returns duplicated values of same row
I have a cursor inside a program unit in Oracle Forms 6
and its supposed to get one row from this cursor ..
but in some values (only some and others not) it gets the same row twice (duplicated) in cursor's active set , I have checked on ROWNUM and it confirmed same row retrieval !!
I checked the table for duplicated values but it returned non , also the selected column is the primary key !!!!
DECLARE...
No activity results to display
Leave a comment: