Search results for query: *

client will not increase the size...

From batch job when the TEMPDB..TABLE table getting updated , it is running for longer time and the TEMPDB databse is running out of space causing problem to the database. There are around 5,20,000 records in TEMPDB..TABLE. Update statement is as follows: UPDATE tempdb..TABLE SET COLUMN1 =...

From batch job when the TEMPDB..TABLE table getting updated , it is running for longer time and the TEMPDB databse is running out of space causing problem to the database. There are around 5,20,000 records in TEMPDB..TABLE. Update statement is as follows: UPDATE tempdb..TABLE SET COLUMN1 =...

How to connect to SYBASE 12 thru Actuate using Sybase Native Driver?? Am able to connect thru ODBC but wanna connect thru Sybase Native Driver... HELP !!!!!

hey techies, thanks all of you for your help.. i have to leave now... would be working to solve the error tommorrow also... thanks for all the help you all provided... see you tommorrow...

how about this query..... where i concatenate in the select query without any variables.... "traunch_type||eff_dt in (select traunch_type||max(eff_dt)" in following select query: if li_row_count > 0 then select sum(traunch_use_lmt) into al_traunch_use_out from seller_traunch...

am also implementing LAST_DDL_TIME.... No probs till now but i was wondering that the same error tracking mechanism is been used in all the 63 SPs then why is the problem been raised for this SP only.... Anyways let me check if error handling is the culprit or not...

i am in process of testing the use of sql_err and err_msg instead of SQLCODE and SQLERRM.... lets see whats the results are.... i will keep posting the results......

Following is the code of my SP which is long but very simple... procedure apptrack_ware_funding_retrieve ( al_seller_id IN NUMBER, al_julian_id_num IN NUMBER, as_pgm_type_cde_uw_out OUT VARCHAR2, as_trust_acct_ind_out OUT VARCHAR2, af_tran_amt_sum_out OUT NUMBER...

i checked those SPs when i encountered this unusual error. They work fine. I think something is wrong with this SP or settings of this SPs. i would be very happy to send you the code. but can i paste the whole code over here. its 6 pages long. Simple SP bu a longer one. if you can send me...

no i am not altering any underlying table and as you said the SP gets recompiled when called if that happens.... but i am encountering this problem very uncanningly.... that is were i am stuck... i don't know why it happens with this SP only.. if underlying table is altered then other 15 SPs...

i have a simple SP which gives me information from 5 different tables... This SP compiles successfully... But sometimes SP gets dropped automatically.. or i don't know what happens but i have to recompile it and then execute it...this happens very regularly.... i don't know if anything is wrong...

My SP does not call any other SP nor i am changing the underlying tables.... The problem occurs uncanningly...

i have a simple SP which gives me information from 5 different tables... This SP compiles successfully... But sometimes SP gets dropped automatically.. or i don't know what happens but i have to recompile it and then execute it...this happens very regularly.... i don't know if anything is wrong...

i have a simple SP which gives me information from 5 different tables... This SP compiles successfully... But sometimes SP gets dropped automatically.. or i don't know what happens but i have to recompile it and then execute it...this happens very regularly.... i don't know if anything is wrong...

i have a simple SP which gives me information from 5 different tables... This SP compiles successfully... But sometimes SP gets dropped automatically.. or i don't know what happens but i have to recompile it and then execute it...this happens very regularly.... i don't know if anything is wrong...