DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2000

    host and bind variables

    hello... what is the difference between host and bind variables . please give with example . How and where they are used?

  2. #2
    Join Date
    Jun 2000
    French Polynesia

    Host variables

    Bind variables are host variables that is, they are defined in the tools environment (Forms, sqlplus or repports...) and used in SQL queries or PL/SQL codes.

    Note that an item in a form or a parameter in a repport is a host variable compare to a local variable in a PL/SQL block.

    Assume that an item in a block form i named LIBELLE
    In order to refere to the value of this host valriable in an assignment statement you will need to write it as
    :LIBELLE := "Text";

    You must however make the difference between a BIND variable and a LEXICAL variable.

    BIND referencing tend to work with the value of the variable, where as, LEXICAL referencing mines replacing the LEXICAL variable in the syntaxe by the value of it.

    LEXICAL variables are possible references when using Repport tool.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.