Results for VARCHAR


21 to 80 of 557 results. Prev  Next
Results per page:   20  | 40 | 60


Pro*Fortran, 9i Release 2 (9.2.0.2)

Writing a Pro*FORTRAN Program

Declaring VARCHAR VariablesA VARCHAR is a set of three variables declared using the syntax

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes and Host Variables

Implicit VARCHAR Group ItemsPro*COBOL implicitly recognizes some group items as VARCHAR host variables when the precompiler … option VARCHAR=YES is specified on the command line. For variable-length single-byte character types … must be declared as level 49 for Pro*COBOL to recognize them as VARCHAR host variables. The VARCHAR … =YES command

Pro*Fortran, 9i Release 2 (9.2.0.2)

Writing a Pro*FORTRAN Program

Referencing VARCHAR Variables* Declare a VARCHAR. EXEC SQL BEGIN DECLARE SECTION VARCHAR*,, EXEC SQL END DECLARE SECTION where … : n Is the maximum length of the VARCHAR; n must be in the range 1 through 32765. VARNAM Is the name … used to reference the VARCHAR in SQL statements; it is called an aggregate name because it … VARCHAR

Concepts, 9i Release 2 (9.2.0.2)

Native Datatypes

VARCHAR2 and VARCHAR DatatypesVARCHAR2 and VARCHAR saves on space used by the table. For example, assume you declare a column … VARCHAR Datatype The VARCHAR datatype is synonymous with the VARCHAR2 datatype. To avoid possible changes

Reference Guide for Informix Dynamic Server Migrations, 9i Release 2 (9.2.0.2)

Oracle and Informix Dynamic Server Compared

VARCHAR(m,r)The Informix Dynamic Server VARCHAR datatype stores varying length single-byte and multibyte … case then, when migrating Informix Dynamic Server tables that contain VARCHAR columns consider … considered. For indexes based on VARCHAR columns, Informix Dynamic Server allocates the maximum storage … . Comparison Semantics Informix

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes and Host Variables

Referencing VARCHAR VariablesIn SQL statements, you reference a VARCHAR variable using the group name prefixed with a colon, as

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Introduction

What is a VARCHAR?Here is a short description of VARCHARs: VARCHAR Description VARCHAR2 A kind of column in the … \", because it is a possible column type. VARCHAR An Oracle \"external datatype\" (datatype code 9 … ). You use this only if you are doing dynamic SQL Method 4, or datatype equivalencing. VARCHAR[n … ] varchar[n] This

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes and Host Variables

Insert NULLs Using VARCHAR VariablesIf you set the length of a VARCHAR variable to zero before performing an UPDATE or INSERT statement

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes and Host Variables

Pass VARCHAR Variables to a Functionfunctions by reference. The following example shows the correct way to pass a VARCHAR variable to a … function: VARCHAR emp_name[20];... emp_name.len = 20; SELECT ename INTO:emp_name FROM emp WHERE … ) VARCHAR *name; {... printf(\"name is %.*s\\n\", name->len, name->arr);... }

JDBC Developer's Guide and Reference, 9i Release 2 (9.2.0.2)

Basic Features

Streaming CHAR, VARCHAR, or RAW ColumnsIf you use the defineColumnType() Oracle extension to redefine a CHAR, VARCHAR, or RAW column as a … , because these columns are usually short. If you try to get a CHAR, VARCHAR, or RAW column as a data

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes and Host Variables

Return NULLs to a VARCHAR VariableOracle automatically sets the length component of a VARCHAR output host variable. If you SELECT or … FETCH a NULL into a VARCHAR, the server does not change the length or array members. Note: If you … select a NULL into a VARCHAR host variable, and there is no associated indicator variable, an ORA

Pro*COBOL® Programmer's Guide, 9i Release 2 (9.2.0.2)

New Features

Implicit Form of VARCHAR Group ItemsThe declaration of COBOL groups that are recognized as VARCHAR are of the following format: nn 49 … range 1 to 65533. The VARCHAR=YES command line option must be specified for Pro*COBOL to recognize … the extended form of the VARCHAR group items. Otherwise, any declarations in the above format will be … interpreted as regular

Globalization Support Guide, 9i Release 2 (9.2.0.2)

Programming with Unicode

Using the VARCHAR Datatype in Pro*C/C++The Pro*C/C++ VARCHAR datatype is preprocessed to a struct with a length field and text buffer … field. The following example uses the C/C++ text native datatype and the VARCHAR Pro*C/C++ datatypes to … OPTION (CHAR_MAP=STRING). text ename[20]. /* unsigned short type */ varchar address[50]. /* Pro*C/C … you use the VARCHAR

Pro*C/C++ Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes and Host Variables

Find the Length of the VARCHAR Array ComponentWhen the precompiler processes a VARCHAR declaration, the actual length of the array element in the … *C/C++ declaration VARCHAR my_varchar[12]; is expanded by the precompiler to struct my_varchar … () function the length of the data for a VARCHAR host variable or a VARCHAR pointer host variable, and … SQLVarcharGetLength()

SQL Reference, 9i Release 2 (9.2.0.2)

Oracle Reserved Words

VALIDATEVALUES * VARCHAR *

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_STRING_PROPERTY( property_name IN VARCHAR, RETURN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOGSTDBY, 2 of 2

SyntaxDBMS_LOGSTDBY.APPLY_SET ( parameter IN VARCHAR, value IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_LOGSTDBY, 2 of 2

SyntaxDBMS_LOGSTDBY.APPLY_UNSET ( parameter IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_USERID( userid OUT VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_APPID( appid OUT VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_TYPE( type IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_APPID( appid IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_USERID( userid IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.LOOKUP_PROPERTY_NAME( new_property_name IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_GROUPID( groupid OUT VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_GROUPID( groupid IN VARCHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_TYPE( type OUT VARCHAR);

Error Messages, 9i Release 2 (9.2.0.2)

Pro*C/C++ Messages (PCC)

PCC-02313 malformed VARCHAR declaration - missing lengthCause: When a VARCHAR is declared, a length specification is mandatory. For example, the following … VARCHAR declaration is meaningless, hence illegal: VARCHAR v1[]; Action: Specify the length for each declared VARCHAR.

Error Messages, 9i Release 2 (9.2.0.2)

Pro*C/C++ Messages (PCC)

PCC-02311 cannot have VARCHAR bit fieldsCause: Host variables cannot contain bit fields. Action: Recode the application to remove the bit fields.

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_SHORT_PROPERTY( property_name IN VARCHAR, RETURN INT);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_INT_PROPERTY( property_name IN VARCHAR, RETURN INT);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_LONG_PROPERTY( property_name IN VARCHAR, RETURN NUMBER);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_FLOAT_PROPERTY( property_name IN VARCHAR, RETURN FLOAT);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_BOOLEAN_PROPERTY( property_name IN VARCHAR, property_value IN BOOLEAN);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_SHORT_PROPERTY( property_name IN VARCHAR, property_value IN INT);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_DOUBLE_PROPERTY( property_name IN VARCHAR, RETURN DOUBLE PRECISION);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_INT_PROPERTY( property_name IN VARCHAR, property_value IN INT);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_FLOAT_PROPERTY( property_name IN VARCHAR, property_value IN FLOAT);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_BYTE_PROPERTY( property_name IN VARCHAR, RETURN INT);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.GET_BOOLEAN_PROPERTY( property_name IN VARCHAR, RETURN BOOLEAN);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_BYTE_PROPERTY( property_name IN VARCHAR, property_value IN INT);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_LONG_PROPERTY( property_name IN VARCHAR, property_value IN NUMBER);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_STRING_PROPERTY( property_name IN VARCHAR, property_value IN VARDHAR);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 3 of 5

SyntaxTYPE aq$_jms_header AS object( replyto sys.aq$_agent, type VARCHAR(100), userid VARCHAR(100), appid … VARCHAR(100), groupid VARCHAR(100), groupseq INT, properties aq$_jms_userproparray, MEMBER … PROCEDURE lookup_property_name (new_property_name IN VARCHAR), MEMBER PROCEDURE set_replyto (replyto IN

Error Messages, 9i Release 2 (9.2.0.2)

Pro*C/C++ Messages (PCC)

PCC-00121 Arrays of VARCHAR pointers are not supportedare allowed. With Pro*C, declare pointers to char[n] and varchar[n] variables as pointers to CHAR or … VARCHAR (with no length specification). Action: Correct or remove the declaration.

Error Messages, 9i Release 2 (9.2.0.2)

Pro*C/C++ Messages (PCC)

PCC-00123 Entire VARCHAR declaration must be on same lineCause: In a Pro*C program, a VARCHAR declaration spans more than one line, which is not allowed

Error Messages, 9i Release 2 (9.2.0.2)

Pro*C/C++ Messages (PCC)

PCC-02397 VARCHAR declarations not permitted in #include fileCause: A VARCHAR declaration was found in a file included using a #include form. Action: Use the … EXEC SQL INCLUDE form to include files with VARCHAR declarations instead.

Error Messages, 9i Release 2 (9.2.0.2)

Pro*COBOL Messages (PCB)

PCB-00321 Implicit varchar host variables are an Oracle extensionCause: An Oracle extension to the ANSI/ISO SQL standard was used. Specifically, an implicit varchar

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 3 of 5

Syntaxsys.aq$_agent), MEMBER PROCEDURE set_type (type IN VARCHAR), MEMBER PROCEDURE set_userid (userid IN … VARCHAR), MEMBER PROCEDURE set_appid (appid IN VARCHAR), MEMBER PROCEDURE set_groupid (groupid IN … VARCHAR), MEMBER PROCEDURE set_groupseq (groupseq IN INT), MEMBER PROCEDURE clear_properties, MEMBER … PROCEDURE

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 4 of 5

SyntaxDBMS_AQJMS.SET_DOUBLE_PROPERTY( property_name IN VARCHAR, property_value IN DOUBLE PRECISION);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT, 2 of 2

SyntaxDBMS_REPCAT.COMMENT_ON_REPSITES ( gname IN VARCHAR2, [ master IN VARCHAR,] comment IN VARCHAR2);

Replication Management API Reference, 9i Release 2 (9.2.0.2)

DBMS_REPCAT

SyntaxDBMS_REPCAT.COMMENT_ON_REPSITES ( gname IN VARCHAR2, [ master IN VARCHAR,] comment IN VARCHAR2);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 3 of 5

SyntaxTYPE aq$_jms_userproperty AS object( name VARCHAR(100), type INT, str_value VARCHAR(2000), num_value NUMBER, java_type INT);

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 3 of 5

Syntaxsys.aq$_agent), MEMBER PROCEDURE set_type (type IN VARCHAR), MEMBER PROCEDURE set_userid (userid IN … VARCHAR), MEMBER PROCEDURE set_appid (appid IN VARCHAR), MEMBER PROCEDURE set_groupid (groupid IN VARCHAR … PROCEDURE set_boolean_property( property_name IN VARCHAR, property_value IN BOOLEAN), MEMBER

Supplied PL/SQL Packages and Types Reference, 9i Release 2 (9.2.0.2)

JMS Types, 3 of 5

Syntax), MEMBER PROCEDURE set_type (type IN VARCHAR), MEMBER PROCEDURE set_userid (userid IN VARCHAR), MEMBER … PROCEDURE set_appid (appid IN VARCHAR), MEMBER PROCEDURE set_groupid (groupid IN VARCHAR), MEMBER … set_boolean_property( property_name IN VARCHAR, property_value IN BOOLEAN), MEMBER PROCEDURE

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-13012 language column must be a char, varchar, or varchar2 typeCause: A language column was specified which is not a char, varchar, or varchar2 type. Action: Specify a language column of correct type.

Error Messages, 9i Release 2 (9.2.0.2)

Pro*C/C++ Messages (PCC)

PCC-02312 arrays of VARCHAR greater than 2 dimensions not allowedCause: A VARCHAR variable having more that 2 dimensions was declared. Multidimensional arrays are

Error Messages, 9i Release 2 (9.2.0.2)

SQL*Module Messages (MOD)

MOD-00029 VARCHAR string at number is larger than 65533 line number in file stringCause: The declared size of VARCHAR host variable exceeds the module limit of 65533 bytes. Action … : Check the declarations, making sure the size of each VARCHAR variable does not exceed the limit of 65533 bytes.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-11210 format column must be a char, varchar, or varchar2 typeCause: A format column was specified which is not a char, varchar, or varchar2 type. Action: Specify a format column of the correct type.

Error Messages, 9i Release 2 (9.2.0.2)

Oracle Text Messages (DRG)

DRG-11211 charset column must be a char, varchar, or varchar2 typeCause: A charset column was specified which is not a char, varchar, or varchar2 type. Action: Specify a charset column of the correct type.





Was this page helpful?

Integrated Cloud Applications & Platform Services