DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: host , bind variables

  1. #1
    Join Date
    Nov 2000
    Posts
    35

    host and bind variables

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

  2. #2
    Join Date
    Jun 2000
    Location
    French Polynesia
    Posts
    16

    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.

    exemple:
    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.

    Bye

    Rayd

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