Oracle Help
in [SQL]
|
using "call" for packaged procedure? After moving a procedure into a package I discovered I can no longer use "call" to invoke the procedure. Can someone explain why this is? Many TIA! old code: call p4_add(:typeid,:reposid,:depotFile,:rev,:tmstamp) new code (broken): call p4.add(:typeid,:reposid,:depotFile,:rev,:tmstamp) ... 29 Aug 2008 10:37
Best idiom for looping over input? After moving a procedure into a package I discovered I can no longer use "call" to invoke the procedure. Can someone explain why this is? Many TIA! old code: call p4_add(:typeid,:reposid,:depotFile,:rev,:tmstamp) new code (broken): call p4.add(:typeid,:reposid,:depotFile,:rev,:tmstamp) ... 28 Aug 2008 16:13
Rman configuration I'm really just curious. when you define default parameters from within RMAN like we have below, does RMAN remember it? Where does it store that info so that it remains persistent? We're thinking to use our control file rather than a recovery catalog. We also want to know if we can code default parameters for ... 28 Aug 2008 15:12
PL/SQL-Oracle Application Developer--Perm On Aug 27, 5:26 pm, "Tom Gugger" <tgug...(a)bex.net> wrote: Tom Gugger Independent Recruiter tgug...(a)bex.net 419-537-9447 Miami, FL WNW sub POSITION # 1 PL/SQL Oracle Application Developer/ Perm This is a career position with a solid company. If after reading the description you are bo... 28 Aug 2008 10:03
fmcus.msb I have built an application using Oracle Forms and Reports and now need to install it on a couple user machines for demo/pilot. There is no Forms Server available to be used for installation, nor is there anyone available to set one up so need to install the forms and reports runtime engine on the client machines w... 29 Aug 2008 15:45
WTF - OTN Forums On Aug 27, 4:03 pm, "Shakespeare" Good thing Usenet is still around... Shakespeare yeah thank God Usenet is not running on Java like OTN is. <shakehead> ... 28 Aug 2008 11:05
Mutating table with old and new ... only Hello, I have been told that something like: create trigger triggername before update of ROW on TABLE for each row when (old.ROW = a and new.ROW = b) begin :new.ROW := :old.ROW; .... message "a could not be updated with b" end; / would cause the mutating table error. Certainly I have tried it out a... 27 Aug 2008 19:45
How to force subquery being the first executed Hi %, I've a question about 'leading' the optimizer. To make it not too simple, it should work from 9.2.0.4 up to 11.1.0.6. I'm selecting from a heavy view (many joins, big result set), using a subquery to restrict the result: select * from heavyView where keys in (select keys from simpleView);... 27 Aug 2008 13:35
Oracle ODBC Linux 64bit Driver Hi, I'm searching for a way to access oracle (and in future other DB systems) using ODBC on a 64bit linux machine. I found unixODBC, but the oracle driver by easysoft listed there is quite expensive. The oracle homepage lists a 32bit linux "ODBCinstant client driver" - is this basically the same thing and c... 27 Aug 2008 13:35
LIKE Question MySQL has this function, was wondering if this can be done with Oracle. Basically a query which uses the LIKE method, but is able to rank the results in relevance, which ones match the most to the fewest?? ... 27 Aug 2008 17:42 |