Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Form designer: sample
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
version: 2.1 end: vcard
--------------302DFE96F0447B73848A5F9C-- Received on Sat Oct 04 1997 - 00:00:00 CDT
![]() |
![]() |