Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Form designer: sample

Form designer: sample

From: Shih-Chi Chiang <shihchic_at_wam.umd.edu>
Date: 1997/10/04
Message-ID: <34367769.515AD04A@wam.umd.edu>

This is a multi-part message in MIME format.

--------------302DFE96F0447B73848A5F9C
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Hi....

    When I want to run a file called "sample.fmb" in the folder c:->orawin->forms45->tutorial. This is a very simple file for tutorial of beginner.
But ther is always a generation error. So I still can't run it now. Does anyone know what's wrong with it?
This is the 1st time I install developer 2000 in my own pc.(OS:win95) Did I miss certain step in the process of installation?  The message is as folowing:

Compiling procedure GET_CUSTOMER_NAME... Compilation error on procedure GET_CUSTOMER_NAME: PL/SQL ERROR 356 at line 5, column 10
'S_CUSTOMER' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling procedure GET_SALES_REP_NAME... Compilation error on procedure GET_SALES_REP_NAME: PL/SQL ERROR 356 at line 5, column 8
'S_EMP' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling procedure GET_PRODUCT_NAME...
Compilation error on procedure GET_PRODUCT_NAME: PL/SQL ERROR 356 at line 6, column 8
'S_PRODUCT' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling ON-CHECK-DELETE-MASTER trigger on ORD_BLK block... Compilation error on ON-CHECK-DELETE-MASTER trigger on ORD_BLK block: PL/SQL ERROR 356 at line 10, column 22
'S_ITEM' must name a table to which the user has access
PL/SQL ERROR 0 at line 10, column 5
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 26, column 3
SQL Statement ignored

Compiling PRE-INSERT trigger on ORD_BLK block... Compilation error on PRE-INSERT trigger on ORD_BLK block: PL/SQL ERROR 303 at line 5, column 8
qualifier 'S_ORD_ID' must be declared
PL/SQL ERROR 0 at line 1, column 1
SQL Statement ignored

Compiling PRE-QUERY trigger on ORD_BLK block... Compilation error on PRE-QUERY trigger on ORD_BLK block: PL/SQL ERROR 356 at line 5, column 22
'S_CUSTOMER' must name a table to which the user has access
PL/SQL ERROR 0 at line 5, column 7
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 22, column 4
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 28, column 10
SQL Statement ignored

Compiling POST-QUERY trigger on ORD_BLK block... Compilation error on POST-QUERY trigger on ORD_BLK block: PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored
PL/SQL ERROR 313 at line 2, column 1
'GET_SALES_REP_NAME' not declared in this scope
PL/SQL ERROR 0 at line 2, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on CUSTOMER_ID item in ORD_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on CUSTOMER_ID item in ORD_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on SALES_REP_ID item in ORD_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on SALES_REP_ID item in ORD_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling PRE-INSERT trigger on ITEM_BLK block... Compilation error on PRE-INSERT trigger on ITEM_BLK block: PL/SQL ERROR 356 at line 12, column 6
'S_ITEM' must name a table to which the user has access
PL/SQL ERROR 0 at line 1, column 1
SQL Statement ignored

Compiling POST-QUERY trigger on ITEM_BLK block... Compilation error on POST-QUERY trigger on ITEM_BLK block: PL/SQL ERROR 313 at line 1, column 1
'GET_PRODUCT_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on PRODUCT_ID item in ITEM_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on PRODUCT_ID item in ITEM_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_PRODUCT_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling procedure GET_CUSTOMER_NAME... Compilation error on procedure GET_CUSTOMER_NAME: PL/SQL ERROR 356 at line 5, column 10
'S_CUSTOMER' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling procedure GET_SALES_REP_NAME... Compilation error on procedure GET_SALES_REP_NAME: PL/SQL ERROR 356 at line 5, column 8
'S_EMP' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling procedure GET_PRODUCT_NAME...
Compilation error on procedure GET_PRODUCT_NAME: PL/SQL ERROR 356 at line 6, column 8
'S_PRODUCT' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling ON-CHECK-DELETE-MASTER trigger on ORD_BLK block... Compilation error on ON-CHECK-DELETE-MASTER trigger on ORD_BLK block: PL/SQL ERROR 356 at line 10, column 22
'S_ITEM' must name a table to which the user has access
PL/SQL ERROR 0 at line 10, column 5
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 26, column 3
SQL Statement ignored

Compiling PRE-INSERT trigger on ORD_BLK block... Compilation error on PRE-INSERT trigger on ORD_BLK block: PL/SQL ERROR 303 at line 5, column 8
qualifier 'S_ORD_ID' must be declared
PL/SQL ERROR 0 at line 1, column 1
SQL Statement ignored

Compiling PRE-QUERY trigger on ORD_BLK block... Compilation error on PRE-QUERY trigger on ORD_BLK block: PL/SQL ERROR 356 at line 5, column 22
'S_CUSTOMER' must name a table to which the user has access
PL/SQL ERROR 0 at line 5, column 7
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 22, column 4
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 28, column 10
SQL Statement ignored

Compiling POST-QUERY trigger on ORD_BLK block... Compilation error on POST-QUERY trigger on ORD_BLK block: PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored
PL/SQL ERROR 313 at line 2, column 1
'GET_SALES_REP_NAME' not declared in this scope
PL/SQL ERROR 0 at line 2, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on CUSTOMER_ID item in ORD_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on CUSTOMER_ID item in ORD_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on SALES_REP_ID item in ORD_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on SALES_REP_ID item in ORD_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling PRE-INSERT trigger on ITEM_BLK block... Compilation error on PRE-INSERT trigger on ITEM_BLK block: PL/SQL ERROR 356 at line 12, column 6
'S_ITEM' must name a table to which the user has access
PL/SQL ERROR 0 at line 1, column 1
SQL Statement ignored

Compiling POST-QUERY trigger on ITEM_BLK block... Compilation error on POST-QUERY trigger on ITEM_BLK block: PL/SQL ERROR 313 at line 1, column 1
'GET_PRODUCT_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on PRODUCT_ID item in ITEM_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on PRODUCT_ID item in ITEM_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_PRODUCT_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling procedure GET_CUSTOMER_NAME... Compilation error on procedure GET_CUSTOMER_NAME: PL/SQL ERROR 356 at line 5, column 10
'S_CUSTOMER' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling procedure GET_SALES_REP_NAME... Compilation error on procedure GET_SALES_REP_NAME: PL/SQL ERROR 356 at line 5, column 8
'S_EMP' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling procedure GET_PRODUCT_NAME...
Compilation error on procedure GET_PRODUCT_NAME: PL/SQL ERROR 356 at line 6, column 8
'S_PRODUCT' must name a table to which the user has access
PL/SQL ERROR 0 at line 2, column 1
SQL Statement ignored

Compiling ON-CHECK-DELETE-MASTER trigger on ORD_BLK block... Compilation error on ON-CHECK-DELETE-MASTER trigger on ORD_BLK block: PL/SQL ERROR 356 at line 10, column 22
'S_ITEM' must name a table to which the user has access
PL/SQL ERROR 0 at line 10, column 5
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 26, column 3
SQL Statement ignored

Compiling PRE-INSERT trigger on ORD_BLK block... Compilation error on PRE-INSERT trigger on ORD_BLK block: PL/SQL ERROR 303 at line 5, column 8
qualifier 'S_ORD_ID' must be declared
PL/SQL ERROR 0 at line 1, column 1
SQL Statement ignored

Compiling PRE-QUERY trigger on ORD_BLK block... Compilation error on PRE-QUERY trigger on ORD_BLK block: PL/SQL ERROR 356 at line 5, column 22
'S_CUSTOMER' must name a table to which the user has access
PL/SQL ERROR 0 at line 5, column 7
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 22, column 4
SQL Statement ignored
PL/SQL ERROR 320 at line 1, column 1
the declaration of the type of this expression is incomplete or malformed
PL/SQL ERROR 0 at line 28, column 10
SQL Statement ignored

Compiling POST-QUERY trigger on ORD_BLK block... Compilation error on POST-QUERY trigger on ORD_BLK block: PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored
PL/SQL ERROR 313 at line 2, column 1
'GET_SALES_REP_NAME' not declared in this scope
PL/SQL ERROR 0 at line 2, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on CUSTOMER_ID item in ORD_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on CUSTOMER_ID item in ORD_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on SALES_REP_ID item in ORD_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on SALES_REP_ID item in ORD_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_CUSTOMER_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling PRE-INSERT trigger on ITEM_BLK block... Compilation error on PRE-INSERT trigger on ITEM_BLK block: PL/SQL ERROR 356 at line 12, column 6
'S_ITEM' must name a table to which the user has access
PL/SQL ERROR 0 at line 1, column 1
SQL Statement ignored

Compiling POST-QUERY trigger on ITEM_BLK block... Compilation error on POST-QUERY trigger on ITEM_BLK block: PL/SQL ERROR 313 at line 1, column 1
'GET_PRODUCT_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

Compiling WHEN-VALIDATE-ITEM trigger on PRODUCT_ID item in ITEM_BLK block...
Compilation error on WHEN-VALIDATE-ITEM trigger on PRODUCT_ID item in ITEM_BLK block:
PL/SQL ERROR 313 at line 1, column 1
'GET_PRODUCT_NAME' not declared in this scope
PL/SQL ERROR 0 at line 1, column 1
Statement ignored

  Shih-Chi Chiang
  Graduate student
  ISR

                <shihchic_at_wam.umd.edu>
                Home: 301 935 5159
                Netscape Conference Address
                Netscape Conference DLS Server

  Additional Information:
  Last Name

           Chiang
  First Name

           Shih-Chi
  Version

           2.1

--------------302DFE96F0447B73848A5F9C
Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Chiang, Shih-Chi 
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Shih-Chi  Chiang
n:              Chiang;Shih-Chi 
org:            ISR
email;internet: shihchic_at_wam.umd.edu
title:          Graduate student
tel;home:       301 935 5159

x-mozilla-cpt: ;0
x-mozilla-html: FALSE
version:        2.1
end:            vcard


--------------302DFE96F0447B73848A5F9C-- Received on Sat Oct 04 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US