New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
PSQL packages [CORE2312] #2736
Comments
Modified by: @dyemanovsummary: Packages => PSQL packages |
Modified by: @asfernandesassignee: Adriano dos Santos Fernandes [ asfernandes ] |
Modified by: @asfernandesstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 3.0 Alpha 1 [ 10331 ] |
Commented by: eXandr (i.reg) Is it possible to declare package variables/constants(global, per connection, per transaction) ? |
Modified by: @dyemanovVersion: 3.0 Alpha 1 [ 10331 ] => |
Commented by: @hvlad Is SQL functions supported in packages ? |
Commented by: @asfernandes Yes. |
Commented by: @hvlad It not works for me. Could you show example here ? |
Commented by: @asfernandes What's the error? |
Commented by: @hvlad CREATE OR ALTER PACKAGE TEST COMMIT RECREATE PACKAGE BODY TEST PROCEDURE P1(I INT) RETURNS (O INT) FUNCTION F1(I INT) RETURNS INT COMMIT EXECUTE PROCEDURE TEST.P1(1) The assert is failed at JrdStatement::verifyAccess(), at line
call stack below > engine12.dll!Jrd::JrdStatement::verifyAccess(Jrd::thread_db * tdbb=0x000000000377e6c0) Line 446 + 0x72 bytes C++ |
Commented by: @asfernandes Your test works for me: SQL> EXECUTE PROCEDURE TEST.P1(1)!
============ I tried to run without autocommit and as non-sysdba user. How to reproduce it? |
Modified by: @pavel-zotovQA Status: No test |
Modified by: @pavel-zotovstatus: Resolved [ 5 ] => Resolved [ 5 ] QA Status: No test => Covered by another test(s) |
Submitted by: @asfernandes
Is related to QA641
Votes: 1
Description:
A package is a group of procedures and functions managed as one entity.
Syntax:
<package_header> ::=
{ CREATE [OR ALTER] | ALTER | RECREATE } PACKAGE <name>
AS
BEGIN
[ <package_item> ... ]
END
Objectives:
- Make functional dependent code separated in logical modules like programming languages does.
Syntax rules:
- A package body should implement all routines declared in the header and in the body start,
with the same signature.
Notes:
- DROP PACKAGE drops the package body before drop its header.
- UDFs (DECLARE EXTERNAL FUNCTION) are currently not supported inside packages.
Examples:
- To come.
Commits: 0145996 ed0e0da
The text was updated successfully, but these errors were encountered: