APPS.AD_LONGTOLOB_PKG dependencies on DBMS_SQL

Line 660: ' rowtab dbms_sql.urowid_table;'||

656: ' cursor c_tab2 is'||
657: ' select apps_rowid, '||l_lob_value_col_name||
658: ' from ad_long_conv_temp2;'||
659: ''||
660: ' rowtab dbms_sql.urowid_table;'||
661: ''||
662: ' begin'||
663: ' open c_tab;'||
664: ''||

Line 730: l_cursor := DBMS_SQL.OPEN_CURSOR;

726: l_offset INTEGER; -- the byte position in the LONG column at which
727:
728: BEGIN
729: l_stmt := 'SELECT '||p_Long_Column_Name||' FROM '||p_Table_Name||' WHERE ROWID = '''||p_Rowid||'''';
730: l_cursor := DBMS_SQL.OPEN_CURSOR;
731: DBMS_SQL.PARSE(l_cursor, l_stmt, DBMS_SQL.NATIVE);
732: --
733: --Define the LONG column.
734: --

Line 731: DBMS_SQL.PARSE(l_cursor, l_stmt, DBMS_SQL.NATIVE);

727:
728: BEGIN
729: l_stmt := 'SELECT '||p_Long_Column_Name||' FROM '||p_Table_Name||' WHERE ROWID = '''||p_Rowid||'''';
730: l_cursor := DBMS_SQL.OPEN_CURSOR;
731: DBMS_SQL.PARSE(l_cursor, l_stmt, DBMS_SQL.NATIVE);
732: --
733: --Define the LONG column.
734: --
735: DBMS_SQL.DEFINE_COLUMN_LONG(l_cursor, 1);

Line 735: DBMS_SQL.DEFINE_COLUMN_LONG(l_cursor, 1);

731: DBMS_SQL.PARSE(l_cursor, l_stmt, DBMS_SQL.NATIVE);
732: --
733: --Define the LONG column.
734: --
735: DBMS_SQL.DEFINE_COLUMN_LONG(l_cursor, 1);
736: --
737: -- Execute the query.
738: --
739: l_ignore := DBMS_SQL.EXECUTE(l_cursor);

Line 739: l_ignore := DBMS_SQL.EXECUTE(l_cursor);

735: DBMS_SQL.DEFINE_COLUMN_LONG(l_cursor, 1);
736: --
737: -- Execute the query.
738: --
739: l_ignore := DBMS_SQL.EXECUTE(l_cursor);
740:
741: IF DBMS_SQL.FETCH_ROWS(l_cursor) > 0 THEN
742: l_offset := 0;
743: l_row_length := 0;

Line 741: IF DBMS_SQL.FETCH_ROWS(l_cursor) > 0 THEN

737: -- Execute the query.
738: --
739: l_ignore := DBMS_SQL.EXECUTE(l_cursor);
740:
741: IF DBMS_SQL.FETCH_ROWS(l_cursor) > 0 THEN
742: l_offset := 0;
743: l_row_length := 0;
744: --
745: -- Get the value of the LONG column piece by piece. Here a loop

Line 753: DBMS_SQL.COLUMN_VALUE_LONG(l_cursor, 1, num_bytes, l_offset, out_val, out_length);

749: LOOP
750: --
751: -- Get the value of a portion of the LONG column.
752: --
753: DBMS_SQL.COLUMN_VALUE_LONG(l_cursor, 1, num_bytes, l_offset, out_val, out_length);
754: IF out_length <> 0 THEN
755: l_offset := l_offset + num_bytes;
756: l_row_length := l_row_length + out_length;
757: ELSE

Line 767: DBMS_SQL.CLOSE_CURSOR(l_cursor);

763: END LOOP;
764: ELSE
765: l_row_length := 0;
766: END IF;
767: DBMS_SQL.CLOSE_CURSOR(l_cursor);
768: RETURN l_row_length ;
769: EXCEPTION
770: WHEN OTHERS THEN
771: -- DBMS_OUTPUT.PUT_LINE ('Errors in function get_long_length');

Line 773: IF DBMS_SQL.is_open(l_cursor) THEN

769: EXCEPTION
770: WHEN OTHERS THEN
771: -- DBMS_OUTPUT.PUT_LINE ('Errors in function get_long_length');
772: -- DBMS_OUTPUT.PUT_LINE(sqlerrm);
773: IF DBMS_SQL.is_open(l_cursor) THEN
774: DBMS_SQL.CLOSE_CURSOR(l_cursor);
775: END IF;
776: END;
777:

Line 774: DBMS_SQL.CLOSE_CURSOR(l_cursor);

770: WHEN OTHERS THEN
771: -- DBMS_OUTPUT.PUT_LINE ('Errors in function get_long_length');
772: -- DBMS_OUTPUT.PUT_LINE(sqlerrm);
773: IF DBMS_SQL.is_open(l_cursor) THEN
774: DBMS_SQL.CLOSE_CURSOR(l_cursor);
775: END IF;
776: END;
777:
778: PROCEDURE write_long_rep