Function plsql

CREATE OR REPLACE FUNCTION my_schema.my_function(param1 IN number) RETURN output1 IS
    cnumber NUMBER;
BEGIN
    cnumber := 2;
    RETURN (cnumber * param1);
EXCEPTION
    WHEN OTHERS THEN
        raise_application_error(-20001, 'An error was encountered - '
            || sqlcode || ' -ERROR- ' || sqlerrm);
END;

Similar codes

1 vote198 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote199 views1 answer
Sql server datetime to string
SQL
0 vote182 views2 answers
Delete query sql server
SQL
1 vote200 views2 answers
Extract weekday from date in sql
SQL
0 vote188 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
1 vote195 views1 answer
SQLite order random
SQL
0 vote196 views4 answers
Creating a comment and reply system PHP and MySQL
SQL
0 vote328 views1 answer
Mysql failed to login as root@localhost
SQL
0 vote218 views1 answer
Multiple like values for single column postgres
SQL
0 vote184 views1 answer
Mysql use password error
SQL