|
From: jose l. f. d. <jos...@ho...> - 2021-02-01 20:41:43
|
2021-02-01 20:55:27,396 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################
2021-02-01 20:55:27,400 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - # Starting SQuirreL SQL Client snapshot-20201226_2251 at 1/02/21 20:55
2021-02-01 20:55:27,400 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - #############################################################################################################
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - SQuirreL SQL Client snapshot-20201226_2251 started: Mon Feb 01 20:55:27 CET 2021
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - Copyright (c) 2001-2020
Colin Bell, Gerd Wagner, Rob Manning and others
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.vendor: Oracle Corporation
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.version: 1.8.0_281
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.runtime.name: Java(TM) SE Runtime Environment
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.name: Windows 10
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.version: 10.0
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - os.arch: amd64
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.dir: D:\Program Files\squirrel-sql-snapshot-20201226_2251
2021-02-01 20:55:27,404 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - user.home: C:\Users\jlfdiaz
2021-02-01 20:55:27,405 [main] INFO net.sourceforge.squirrel_sql.client.SquirrelLoggerFactory - java.home: C:\Program Files\Java\jre1.8.0_281
2021-02-01 20:55:29,568 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.laf.LAFRegister - Setting lookandfeel class: javax.swing.plaf.metal.MetalLookAndFeel
2021-02-01 20:55:30,660 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.plugin.PluginQueryTokenizerPreferencesManager - prefs.xml not found - will be created
2021-02-01 20:55:30,670 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.refactoring.prefs.RefactoringPreferencesManager - prefs.xml not found - will be created
2021-02-01 20:55:30,753 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin laf created in 1 ms, loaded in 1.128 ms, initialized in 0 ms, total 1.129 ms.
2021-02-01 20:55:30,753 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin sqlscript created in 0 ms, loaded in 0 ms, initialized in 12 ms, total 12 ms.
2021-02-01 20:55:30,754 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin oracle created in 2 ms, loaded in 0 ms, initialized in 34 ms, total 36 ms.
2021-02-01 20:55:30,754 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin refactoring created in 1 ms, loaded in 0 ms, initialized in 7 ms, total 8 ms.
2021-02-01 20:55:30,754 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin codecompletion created in 2 ms, loaded in 0 ms, initialized in 7 ms, total 9 ms.
2021-02-01 20:55:30,755 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin sqlbookmark created in 2 ms, loaded in 0 ms, initialized in 6 ms, total 8 ms.
2021-02-01 20:55:30,755 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin syntax created in 1 ms, loaded in 0 ms, initialized in 48 ms, total 49 ms.
2021-02-01 20:55:30,755 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin dataimport created in 1 ms, loaded in 1 ms, initialized in 1 ms, total 3 ms.
2021-02-01 20:55:30,756 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin dbcopy created in 1 ms, loaded in 0 ms, initialized in 9 ms, total 10 ms.
2021-02-01 20:55:30,756 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin dbdiff created in 2 ms, loaded in 0 ms, initialized in 5 ms, total 7 ms.
2021-02-01 20:55:30,756 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.client.Application - Plugin graph created in 1 ms, loaded in 0 ms, initialized in 7 ms, total 8 ms.
2021-02-01 20:55:52,665 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.AxionDialectExt$AxionDialectHelper
2021-02-01 20:55:52,692 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DB2DialectExt$DB2DialectHelper
2021-02-01 20:55:52,694 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DaffodilDialectExt$DaffodilDialectHelper
2021-02-01 20:55:52,695 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DB2DialectExt$DB2DialectHelper
2021-02-01 20:55:52,695 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.DerbyDialectExt$DerbyDialectHelper
2021-02-01 20:55:52,697 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.FirebirdDialectExt$FirebirdDialectHelper
2021-02-01 20:55:52,699 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.FrontBaseDialectExt$FrontBaseDialectHelper
2021-02-01 20:55:52,699 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.GenericDialectHelper
2021-02-01 20:55:52,700 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.HADBDialectExt$HADBDialectHelper
2021-02-01 20:55:52,701 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.H2DialectExt$H2DialectHelper
2021-02-01 20:55:52,705 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.HSQLDialectExt$HSQLDialectHelper
2021-02-01 20:55:52,711 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.InformixDialectExt$InformixDialectHelper
2021-02-01 20:55:52,713 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.InterbaseDialectExt$InterbaseDialectHelper
2021-02-01 20:55:52,715 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.IngresDialectExt$IngresDialectHelper
2021-02-01 20:55:52,719 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.MAXDBDialectExt$MAXDBDialectHelper
2021-02-01 20:55:52,721 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.McKoiDialectExt$McKoiDialectHelper
2021-02-01 20:55:52,724 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.MySQLDialectExt$MySQLDialectHelper
2021-02-01 20:55:52,724 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.MySQLDialectExt$MySQLDialectHelper
2021-02-01 20:55:52,727 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.NetezzaDialextExt$NetezzaDialectHelper
2021-02-01 20:55:52,728 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.GreenplumDialectExt$GreenplumDialectHelper
2021-02-01 20:55:52,730 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.OracleDialectExt$OracleDialectHelper
2021-02-01 20:55:52,731 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.PointbaseDialectExt$PointbaseDialectHelper
2021-02-01 20:55:52,733 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.PostgreSQLDialectExt$PostgreSQLDialectHelper
2021-02-01 20:55:52,734 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.ProgressDialectExt$ProgressDialectHelper
2021-02-01 20:55:52,736 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.SybaseDialectExt$SybaseDialectHelper
2021-02-01 20:55:52,736 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.SybaseDialectExt$SybaseDialectHelper
2021-02-01 20:55:52,737 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.SQLServerDialectExt$SQLServerDialectHelper
2021-02-01 20:55:52,738 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.TimesTenDialectExt$TimesTenDialectHelper
2021-02-01 20:55:52,740 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.IntersystemsCacheDialectExt$CacheHelper
2021-02-01 20:55:52,741 [pool-1-thread-1] INFO org.hibernate.dialect.Dialect - Using dialect: net.sourceforge.squirrel_sql.fw.dialects.GenericDialectHelper
2021-02-01 20:55:52,826 [Session Connection Keep-Alive (FACC)] INFO net.sourceforge.squirrel_sql.client.session.SessionConnectionKeepAlive - SessionConnectionKeepAlive (FACC) running SQL: select 1 from dual
2021-02-01 20:55:53,869 [AWT-EventQueue-1] INFO net.sourceforge.squirrel_sql.plugins.oracle.OraclePlugin - setTimezoneForSession: attempting to set the session timezone to : Europe/Paris
2021-02-01 20:57:11,979 [Thread-6] ERROR net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Failed to load stored procedures
java.sql.SQLSyntaxErrorException: ORA-00904: "ALL_ARGUMENTS"."SUBPROGRAM_ID": identificador no válido
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:494)
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:446)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1054)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:252)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:612)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:226)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:59)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:747)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:904)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1082)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3780)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1343)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3822)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1165)
at oracle.jdbc.OracleDatabaseMetaData.getProcedures(OracleDatabaseMetaData.java:1837)
at net.sourceforge.squirrel_sql.fw.sql.SQLDatabaseMetaData.getProcedures(SQLDatabaseMetaData.java:755)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadStoredProcedures(SchemaInfo.java:531)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.loadStoredProcedures(SchemaInfo.java:367)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.privateLoadAll(SchemaInfo.java:305)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:198)
at net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo.reloadAll(SchemaInfo.java:188)
at net.sourceforge.squirrel_sql.client.session.mainpanel.objecttree.ObjectTree$3.run(ObjectTree.java:293)
at net.sourceforge.squirrel_sql.fw.util.TaskExecuter.run(TaskExecuter.java:82)
at java.lang.Thread.run(Unknown Source)
Caused by: Error : 904, Position : 1203, Sql = SELECT
-- Standalone procedures and functions
NULL AS procedure_cat,
owner AS procedure_schem,
object_name AS procedure_name,
NULL,
NULL,
NULL,
'Standalone procedure or function' AS remarks,
DECODE(object_type, 'PROCEDURE', 1,
'FUNCTION', 2,
0) AS procedure_type
, NULL AS specific_name
FROM all_objects
WHERE (object_type = 'PROCEDURE' OR object_type = 'FUNCTION')
AND owner LIKE :1 ESCAPE '/'
AND object_name LIKE :2 ESCAPE '/'
UNION ALL SELECT
-- Packaged procedures --
object_name AS procedure_cat,
owner AS procedure_schem,
procedure_name AS procedure_name,
NULL,
NULL,
NULL,
'Packaged procedure' AS remarks,
1 AS procedure_type
, NULL AS specific_name
FROM all_procedures
WHERE procedure_name IS NOT NULL
AND object_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND procedure_name LIKE :7 ESCAPE '/'
AND NOT EXISTS (SELECT NULL
FROM all_arguments
WHERE argument_name IS NULL
AND in_out = 'OUT'
AND data_level = 0
AND package_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND object_name LIKE :7 ESCAPE '/'
AND all_procedures.object_id = all_arguments.object_id AND all_procedures.subprogram_id = all_arguments.subprogram_id)UNION ALL SELECT
-- Packaged functions
package_name AS procedure_cat,
owner AS procedure_schem,
object_name AS procedure_name,
NULL,
NULL,
NULL,
'Packaged function' AS remarks,
2 AS procedure_type
, NULL AS specific_name
FROM all_arguments
WHERE argument_name IS NULL
AND in_out = 'OUT'
AND data_level = 0
AND package_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND object_name LIKE :7 ESCAPE '/'
ORDER BY procedure_schem, procedure_name
, OriginalSql = SELECT
-- Standalone procedures and functions
NULL AS procedure_cat,
owner AS procedure_schem,
object_name AS procedure_name,
NULL,
NULL,
NULL,
'Standalone procedure or function' AS remarks,
DECODE(object_type, 'PROCEDURE', 1,
'FUNCTION', 2,
0) AS procedure_type
, NULL AS specific_name
FROM all_objects
WHERE (object_type = 'PROCEDURE' OR object_type = 'FUNCTION')
AND owner LIKE :1 ESCAPE '/'
AND object_name LIKE :2 ESCAPE '/'
UNION ALL SELECT
-- Packaged procedures --
object_name AS procedure_cat,
owner AS procedure_schem,
procedure_name AS procedure_name,
NULL,
NULL,
NULL,
'Packaged procedure' AS remarks,
1 AS procedure_type
, NULL AS specific_name
FROM all_procedures
WHERE procedure_name IS NOT NULL
AND object_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND procedure_name LIKE :7 ESCAPE '/'
AND NOT EXISTS (SELECT NULL
FROM all_arguments
WHERE argument_name IS NULL
AND in_out = 'OUT'
AND data_level = 0
AND package_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND object_name LIKE :7 ESCAPE '/'
AND all_procedures.object_id = all_arguments.object_id AND all_procedures.subprogram_id = all_arguments.subprogram_id)UNION ALL SELECT
-- Packaged functions
package_name AS procedure_cat,
owner AS procedure_schem,
object_name AS procedure_name,
NULL,
NULL,
NULL,
'Packaged function' AS remarks,
2 AS procedure_type
, NULL AS specific_name
FROM all_arguments
WHERE argument_name IS NULL
AND in_out = 'OUT'
AND data_level = 0
AND package_name IS NOT NULL
AND owner LIKE :6 ESCAPE '/'
AND object_name LIKE :7 ESCAPE '/'
ORDER BY procedure_schem, procedure_name
, Error Msg = ORA-00904: "ALL_ARGUMENTS"."SUBPROGRAM_ID": identificador no válido
at oracle.jdbc.driver.T4CTTIoer11.processError(T4CTTIoer11.java:498)
... 24 more
|
