我的论坛主题

• 求助javascript in PL/SQL

  2008-12-04 00:27:12   /   WEB程序开发

  When I click on the check box in right side, I want the last name will be filled by 7,8,9 those are pot luck number.The boxes are owa_util.ident_arr type and click on the check box will use onfocus = getpotluck(n,m,z).The n,m,z are passed into the javascript when I tested them, but I do not know how to assign these values into the boxes.Please help!Thank you in advance.See attached page and codes.

  查看(183) 评论(3)

• Help!! Where should I look at to find Bottleneck?

  2008-11-12 09:05:48   /   Oracle开发

  I have a package and it was running ok in oracle 9i (about 30 minutes) now, it runs for one hour and 20 minutes. This package does sorting, selecting, updating and inserting. I don’t know where I should look at to find the slowdown cause.Thank you in advance.

  查看(205) 评论(5)

• 请教 a best way to Implement this task!

  2008-09-18 04:00:57   /   Oracle开发

  All,An agreement page on web is needed to sign and store it. Somebody suggested to make a *.pdf file and let users open and save it into their PC, and then after user sign the page(type name), upload into database.I would like to hear other options and how do I implement.(plus: only the name and date fields can be changed on the page)Please help!Thank you in advance.

  查看(189) 评论(3)

• Oracle Report sorting problem

  2008-08-29 05:36:06   /   Oracle开发

  All,We have an oracle report and we setup the sorting by last name and first name, when we run it from web application, the sorting does no work.Where should I look up for the problem. Thank you!See attached file for the report editor. On the Q1, we did order by last_name, first_name.

  查看(220) 评论(2)

• How do code this SQL?

  2008-08-08 22:07:23   /   Oracle开发

  There is a telephone table with the following columnsID, SEQ_NO, PHONE_TYPE, PHOONE_NUMBER , STATUS_IND etc..Sometime, we delete some rows from the phone table and some people records do not have continuous seq_no. For instance,IDSEQ_NO1 11 21 31 91 12I want to select any ID from table if it has no continues seq_no. One ID for each case. The above case should be selected.How do code this sql?Thank you in advance.

  查看(471) 评论(11)

• How to re-use (re-define) a VARRAY?

  2008-08-06 05:07:06   /   Oracle数据库管理

  I wrote a script to print items. Each person may have max 50 records and I only print out 15 records.I set a varray to 50 to hold records that fetch from a cursor and then print out 15 records in one line.The problem is that after processed two people, the varray reached to 50 and the error occurred below.I am wondering if I can re-init (or re-define) the varray for each person. Please help. (see attached my script)Thank you very much in advance.When I processSQL> @c: empchkl

  查看(163) 评论(2)

• ERROR: ORA-04030: out of process memory

  2008-06-18 05:18:29   /   Oracle开发

  We have a view and whenever I use it, it gave me below error.ERROR: ORA-04030: out of process memory when trying to allocate 64544 bytes (sort subheap,sort key).select * from yu_viewwhere term_code >=code;This view has so many colums and use many functions.Please help.Thank you.

  查看(454) 评论(3)

• What is the limitation of UTL_FILE.PUT_LINE length?

  2008-06-12 05:26:43   /   Oracle开发

  My output file has 3350 char long per line (l_line varchar2(3325)) and I has error when I write UTL_FILE.PUT_LINE (l_file, l_line)ERROR: ORA-29285: file write error.When I reduced the length to 1000 char (l_line varchar2(1000)), it works fine. How do I resolve the problem?Does this regard with the system setting?Please help.Thank you in advance.

  查看(660) 评论(12)

• Why it does not work? Help!!!

  2008-04-30 04:00:11   /   Oracle开发

  In my pl/sql,I validate fields f1 and f2 (both are varchar2)I coded:if f1 is null and f2 is not null thendo not insertand show error;end if;Or I tried:if f1 is not null and f2 is not null theninsert;elsedo not insert and show error;end if;But, when I filled f1 and left f2 empty, the record still inserted into table.NOTE: The f1 is filled through web page -- input type

  查看(427) 评论(6)

• how to list multi-rows from one row in table

  2008-03-06 23:06:20   /   Oracle开发

  I have a table asid, name, contact1, phone_home, cell_phone,work_phone, contact2, phone_home, cell_phone, work_phone, contact3, phone_home, cell_phone, work_phone in one row.I want to use one select statement to showid ,name, contact1, phone_home,id ,name, contact1, cell_phone,id ,name, contact1, work_phoneid, name, contact2, phone_home,id ,name, contact2, cell_phone,id ,name, contact2, work_phoneid, name, contact3, phone_home,id, name, contact3, cell_phone,id,

  查看(281) 评论(2)