Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Long Raw in Oracle 8.0
Hi, I need to copy LONG RAW value from one table to another. I get ORA-06502 PL/SQL: numeric or value error What is wrong here? Thank you all. Leah ------------------------- declare v_IMAGE long raw; begin SELECT IMAGE INTO v_IMAGE FROM IMAGES WHERE IMAGE_ID = 4; UPDATE...- leburs
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
DBMS_SQL and REF CURSOR (Oracle 7)
Thank you for reply, but it is not compiled this way. In the original way it is compiled but gives a runtime error.- leburs
- Post #3
- Forum: Oracle: All versions
-
DBMS_SQL and REF CURSOR (Oracle 7)
Hello, What I’m missing in the following: PROCEDURE proc( p_var1 IN varchar2, … p_cur In OUT cur_type) IS lnCursor INTEGER; lnDummy INTEGER; lvcSql VARCHAR2(2000); v_where varchar2(1000); BEGIN --v_where...- leburs
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Forms 4.5: Is this possible without procedure?
I've solved it not basing on table. Unfortunately, last name is not included in "main" base table which contains details, linked by person id. It's not necessarily 1:1, it's possible to see same Last name several times, if it has many detail rows.- leburs
- Post #3
- Forum: Oracle: Enterprise Developer Suite
-
Forms 4.5: Is this possible without procedure?
Hello, Does somebody know if it's possible to do in Forms 4.5 the following: On the left part of the screen we should see the list of people ordered by Last name. Last names come from a view (not-updateable, Oracle 7). On the right part against each person we should see a row of his details...- leburs
- Thread
- Replies: 3
- Forum: Oracle: Enterprise Developer Suite
