Recent content by mike778

oh, you where right with the lower level, thank you. greetings, mike

I tried this "on message" trigger: DECLARE lv_errcod NUMBER := MESSAGE_CODE; BEGIN IF lv_errcod = 40350 THEN null; end if; END; but doesnt work :-(.

I run exec_query from formsbuilder. when he doesnt find anything he always writes: FRM-40350: Query caused no records to be retrieved. But, I don't want him to do that, instead he should write nothing. has anybody an idea how to make him shut up? :-) thanks, greetings, Michael

Great, thank you! This saves me a lot of time! So I am done for today then. :-) greetings, Michael

Does anybody have a add_minute function? In a library or something? would be great, since I can't find an oracle minute function and i am to lazy to make one. thanks, Michael

Oh, thank you! And Execute Immediate also doesnt work with formsbuilder? greetings, mike

I want to write and read with formsbuilder a database variable, i tried it like this: pa_preval.tbl_proz2csv(1):='he'; where pa_preval is the name of the package and tbl_proz2csv the table declared in the package. it works well with sql plus, but not in a formsbuilder trigger :-(. any ideas...

jep, problem is, that i don't know the name before runtime. i get it from a database table. will try the global variable thing, but would have prefered to return the value directly... greetings, mike

It works the way dima wrote, but the problem I got now is, that my function returns a table. tried it like this, but didnt work :-(. declare i_tbl pa_preval.t_Chartbl; begin execute immediate 'begin :1:=testei2; end;' using out i_tbl; dbms_output.put_line(i_tbl(1)); end; do you have...

Is there a way to get a value out of an execue imediate statement? like this: execute immediate 'declare x varchar2;begin x:=function(2) end;' i want to get x out of that statement. any ideas? thanks a lot, mike

thanks for the fast answers! I use execute immediate 'begin ' || proc || '; end;'; greetings, michael

I want to write the name of my procedure into a varchar, and then start it. the problem ist that i dont know the name of the procedure before runtime. something like this procname := "newitem"; --new item is name of a possibel procedure. callprocedure (procname); --call procedure...