Click here to Skip to main content
16,016,736 members
Home / Discussions / Database
   

Database

 
GeneralRe: SQL Query (on access) Pin
Guillermo Rivero27-Jan-04 2:22
Guillermo Rivero27-Jan-04 2:22 
GeneralRe: SQL Query (on access) Pin
-Dr_X-27-Jan-04 2:28
-Dr_X-27-Jan-04 2:28 
GeneralSQL Server - sa password Pin
Kant26-Jan-04 10:04
Kant26-Jan-04 10:04 
GeneralRe: SQL Server - sa password Pin
Mazdak26-Jan-04 10:10
Mazdak26-Jan-04 10:10 
GeneralRe: SQL Server - sa password Pin
Kant26-Jan-04 11:19
Kant26-Jan-04 11:19 
Generaltry to get trigger_body over 32KB size Pin
yu-yu25-Jan-04 14:43
yu-yu25-Jan-04 14:43 
GeneralRe: try to get trigger_body over 32KB size Pin
Guillermo Rivero25-Jan-04 16:06
Guillermo Rivero25-Jan-04 16:06 
GeneralRe: try to get trigger_body over 32KB size Pin
yu-yu25-Jan-04 17:30
yu-yu25-Jan-04 17:30 
hi,

thank you for your mail.
The code getting trigger_body from DB using ODP.NET is the following.

------------------------------------------------------------
string sSQL = "select trigger_body from user_triggers where trigger_name='" + sName + "'";

OracleCommand com = conn.CreateCommand();
com.CommandText = sSQL;
com.InitialLONGFetchSize = 32767; // Maxvalue
OracleDataReader reader = com.ExecuteReader();

string sResultString = string.Empty;

reader.Read();
if (!reader.IsDBNull(0))
{
sResultString = reader.GetOracleString(0);
}
reader.Close();
-------------------------------------------------------------

best regards,

yu-yu

GeneralRe: try to get trigger_body over 32KB size Pin
Guillermo Rivero26-Jan-04 3:20
Guillermo Rivero26-Jan-04 3:20 
GeneralRe: try to get trigger_body over 32KB size Pin
yu-yu26-Jan-04 20:24
yu-yu26-Jan-04 20:24 
GeneralRe: try to get trigger_body over 32KB size Pin
Guillermo Rivero27-Jan-04 2:17
Guillermo Rivero27-Jan-04 2:17 
GeneralRe: try to get trigger_body over 32KB size Pin
yu-yu27-Jan-04 15:33
yu-yu27-Jan-04 15:33 
GeneralRe: try to get trigger_body over 32KB size Pin
yu-yu28-Jan-04 0:00
yu-yu28-Jan-04 0:00 
GeneralRe: try to get trigger_body over 32KB size Pin
Guillermo Rivero28-Jan-04 4:42
Guillermo Rivero28-Jan-04 4:42 
GeneralRe: try to get trigger_body over 32KB size Pin
yu-yu28-Jan-04 14:43
yu-yu28-Jan-04 14:43 
GeneralRe: try to get trigger_body over 32KB size Pin
Guillermo Rivero29-Jan-04 2:01
Guillermo Rivero29-Jan-04 2:01 
GeneralRe: try to get trigger_body over 32KB size Pin
yu-yu29-Jan-04 3:58
yu-yu29-Jan-04 3:58 
GeneralRe: try to get trigger_body over 32KB size Pin
Guillermo Rivero29-Jan-04 4:21
Guillermo Rivero29-Jan-04 4:21 
GeneralDataTable Pin
Guinness4Strength25-Jan-04 7:16
Guinness4Strength25-Jan-04 7:16 
GeneralRe: DataTable Pin
-Dr_X-25-Jan-04 8:22
-Dr_X-25-Jan-04 8:22 
GeneralRe: DataTable Pin
Rein Hillmann25-Jan-04 21:01
Rein Hillmann25-Jan-04 21:01 
Generalseach or rowfilter by word Pin
Member 76660824-Jan-04 12:11
Member 76660824-Jan-04 12:11 
GeneralRe: seach or rowfilter by word Pin
-Dr_X-24-Jan-04 14:17
-Dr_X-24-Jan-04 14:17 
GeneralSQL Server 2000 date comparision Pin
Sarvesvara (BVKS) Dasa23-Jan-04 22:28
Sarvesvara (BVKS) Dasa23-Jan-04 22:28 
GeneralRe: SQL Server 2000 date comparision Pin
Mazdak24-Jan-04 2:10
Mazdak24-Jan-04 2:10 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.