Calling Procedure

Skip to end of metadata

Created by OO_SeHwan Lim, last modified by OO_heerock on Sep 17, 2012

Go to start of metadata

Procedure
Call Proc in Embedded-SQL
Sample Code
Difference from ORACLE in Procedure

Procedure

It is similar to PL/SQL of ORACLE.

Call Proc in Embedded-SQL

APRE doesn't support functionality as follows.
ALTIBASE HDB doesn't support returning array-result.
ALTIBASE HDB doesn't support a external procedure. (like procedure that it is stored in library-files)

Sample Code

Difference from ORACLE in Procedure

If you execute a procedure having DML statement in auto-commit mode, you can search records affected after execution of procedure is complete.

If you want to do it with ORACLE-style, you have to execute a procedure after change to Non-Autocommit mode in your session.

No labels

Icon

Icon

Copyright ⓒ 2000~2012 ALTIBASE Corporation. All Rights Reserved.
This document is provided for information purposes only and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission. ALTIBASE is a registered trademark of ALTIBASE Corporation and/or its affiliates. Other names may be trademarks of their respective owners.