Parallel Query error
Posted: Mon 28 Feb 2005 20:25
When I am connected via OCI, I get this error in my query. When I am connected in NET8, I don't. Neither do I get it when running the query from PL/SQL. I don't get it, the query is exactly the same, why would it work with one type of connection and not another?
Here is the error
ORA-12801 error signaled in parallel query server Pxxx
ORA-00600 internal error code, arguments [15804], [9], [14], [13],[],[],[],[]
it happens when I do a .next on the query but it is not the first .next, nor is it EOF.
Here is the text of the query's definition (Delphi 5), ODAC 5.50.0.16
object qryTables: TOraQuery
Session = sesAARMS
SQL.Strings = (
'select distinct TRIM(a.table_name) TABLE_NAME,a.level_number fro' +
'm a_level_tab a,primary_keys_all p where trim(a.table_name) = tr' +
'im(p.table_name) order by level_number, TRIM(table_name) '
'')
ReadOnly = True
Left = 224
Top = 8
object StringField1: TStringField
FieldName = 'TABLE_NAME'
Required = True
Size = 30
end
end
Here is the error
ORA-12801 error signaled in parallel query server Pxxx
ORA-00600 internal error code, arguments [15804], [9], [14], [13],[],[],[],[]
it happens when I do a .next on the query but it is not the first .next, nor is it EOF.
Here is the text of the query's definition (Delphi 5), ODAC 5.50.0.16
object qryTables: TOraQuery
Session = sesAARMS
SQL.Strings = (
'select distinct TRIM(a.table_name) TABLE_NAME,a.level_number fro' +
'm a_level_tab a,primary_keys_all p where trim(a.table_name) = tr' +
'im(p.table_name) order by level_number, TRIM(table_name) '
'')
ReadOnly = True
Left = 224
Top = 8
object StringField1: TStringField
FieldName = 'TABLE_NAME'
Required = True
Size = 30
end
end