Search results for query: *

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

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

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...

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

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...