Comments by Member 13944807

Member 13944807 30-Aug-18 8:55am View

Thank you for sharing your knowledge with me!!!
My requirement is to save million of records from result set of sql into one txt file
Is there any other alternative???

Member 13944807 30-Aug-18 8:26am View

Thanks for improving my code!!!
Same query if executed as it is @ SQLDeveloper; file is getting created & records are getting inserted in newly created file as well!!

Member 13944807 30-Aug-18 8:25am View

Thanks for your suggestion!!!
Code: 6550
Message: ORA-06550: line 2, column 9:
PLS-00103: Encountered the symbol "D" when expecting one of the following:
:= . ( @ % ;
This is the Exception I faced!!!

Member 13944807 30-Aug-18 8:01am View

Deleted

Thanks for improving my code!!!
Same query if executed as it is @ SQLDeveloper; file is getting created & records are getting inserted in newly created file as well!!

Member 13944807 30-Aug-18 7:55am View

Deleted

Thanks for your suggestion!!!
Code: 6550
Message: ORA-06550: line 2, column 9:
PLS-00103: Encountered the symbol "D" when expecting one of the following:
:= . ( @ % ;
This is the Exception I faced!!!

Member 13944807 30-Aug-18 6:59am View

Thanks for your suggestions!!!

Using mOracleConnection As New OracleConnection(mConnectionString)
mOracleConnection.Open()
Dim mOracleCommand As OracleCommand
Dim mOracleDataReader As OracleDataReader
mOracleCommand = mOracleConnection.CreateCommand()
mOracleCommand.CommandType = CommandType.Text
mOracleCommand.CommandText = GetStrSQL()
mOracleCommand.ExecuteNonQuery()
End Using

Private Sub GetStrSQL() AS String

Dim mStrSQL AS New StringBuilder
With mStrSQl
.AppendLine(" spool D:\30Aug\Testing.txt ")

.AppendLine(" SELECT * FROM [Payroll.Payslip].Payslip WHERE PayslipID > 1500; ")
.AppendLine(" spool off ")

End With

End Private

Comments by Member 13944807 (Top 6 by date)