This content has been marked as final. Show 3 replies
Where are you running this exactly?
Did you connect in Server explorer using ODP.NET data source and then right click on a connection and choose "Query Window"?
I use the query inside .Net as a string. Then I call it like this.
Dim SQL AS String = "The query" Dim oConn AS String = "Connection string" Dim com As OracleCommand com = New OracleCommand(SQL, oConn) com.CommandType = CommandType.Text com.ExecuteNonQuery()
The ORA-4030 is a database side problem - you are running out of memory on the server. You are going to need to contact your DBA for assistance.
Googling that error number will give you a little more insight, for example: