New answers tagged functions
As you can see from the definition you provided for [dbo].[ConfigData], both Value and ValueInUse are defined as SQL_VARIANT data types. The error message you are receiving is: Msg 257, Level 16, State 3, Procedure usp_SysConfigReport1, Line 19 Implicit conversion from data type sql_variant to int is not allowed. Use the CONVERT function to run this ...
To remove DB_DOMAIN from DB_LINKS. ALTER SYSTEM SET global_names = false SCOPE = SPFILE; ALTER SYSTEM SET db_domain = '' SCOPE = SPFILE; UPDATE GLOBAL_NAME SET GLOBAL_NAME = [Name without db_domain]; then restart, DB and Listener. However, I still do not know how to use this with domain.
The problem is that you cannot use parameters as object names (tables, columns, etc.) in straight SQL statements, like your ALTER TABLE above. I use 'straight' here as an opposite of 'dynamic' - the thing you need: ... loop EXECUTE format($$ALTER TABLE %I SET SCHEMA TO data_archived$$, table_rec.table_name); END loop; ... Notes: ...
This is a 4th option, using out parameters? create or replace function getLicenseStatus (in_license_no varchar2, l_status out varchar2, l_status_dt out varchar2) as begin SELECT status, status_dt into into l_status, l_status_dt from tbl_license where licence_no=in_license_no; end;
Top 50 recent answers are included