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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: sofiagomes
- Order by date
-
Pro*C and Fetched column is null
I'm using this code to execute a list of stored procedures: EXEC SQL EXECUTE DECLARE X NUMBER; MSG_ERRO VARCHAR2(255); cursor_handle INTEGER; procedure_run INTEGER; BEGIN...- sofiagomes
- Thread
- Replies: 0
- Forum: Oracle: All versions
-
Pro*C versus Dynanic SQL
Hello all! Does anyone know about problems with Pro*C programs using stored procedures wich use dynamic sql (using dbms_sql package) ? I have a program that simply came with ORA-01405 (fetched column is null) when i changed stored procedured to use dbms_sql package... I tried to recompile but...- sofiagomes
- Thread
- Replies: 1
- Forum: Oracle: All versions
-
Accessing a partitioned table in a Cursor
Sorry, but i'm sure I'm using the same partition name. This is the statement I ran under SQL PLUS: >SELECT * >FROM postps_successful_calls >partition(D0703) >WHERE >tariff=3; This is the cursor definition under PL/SQL, I pass 'D0703' on parameter <particao>: CURSOR cur_total_msisdn (data...- sofiagomes
- Post #3
- Forum: Oracle: All versions
-
Accessing a partitioned table in a Cursor
I'm trying to define in a stored procedure a cursor to bring data at a specified partition (given by a parameter). The problem is that I get ORA-02149: Specified partition does not exist, and that's the same partition name I use in the next statement: >SELECT * >FROM postps_successful_calls...- sofiagomes
- Thread
- Replies: 4
- Forum: Oracle: All versions
